Option Base 1
Private Sub CommandButton1_Click()
c = Range("A1:A255").End(xlToRight).Column
Dim tablo
tablo = UsedRange
Dim tablo1
ReDim tablo1(UBound(tablo), 1 To c)
For X = 1 To UBound(tablo)
If Rows(X).Hidden = False Then
j = j + 1
For Y = 1 To c
tablo1(j, Y) = tablo(X, Y)
Next Y
End If
Next
Cells.ClearContents
[A1].Resize(UBound(tablo1, 1), UBound(tablo1, 2)).Value = tablo1
End Sub