Hello,

i am new in VBA and I am looking a VBA code to :
After a filter on the colmun (A:A) select the first blank selet and copy data

Please find the code who is not working :
Range("A2", Cells(Rows.Count, "A").End(xlDown)).SpecialCells(xlCellTypeVisible).Cells(1, 1).Offset(0, 0).Select


Thanks for your help