1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| Dim c, firstAddress As Variant
Dim mescellules As String
With Worksheets("T_GDS").Range("a2:Q180")
Set c = .Find("*", LookIn:=xlValues, Lookat:=xlWhole) '
If Not c Is Nothing Then
firstAddress = c.Address
Do
If c.Value <> 0 Then
If mescellules = "" Then
mescellules = c.Address(0, 0)
Else
mescellules = mescellules & "," & c.Address(0, 0)
End If
End If
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End With
Range(mescellules).Select
Selection.Copy |
Partager