Customizing selection with a Macro

[kanelones]

Hello Guys.

Got a spreadsheet, where once is filetered, need to copy my selection to another sheet, but at the time i record ,this sentence:
Range(Selection, Selection.End(xlDown)).Select, appears to work only this time .. ( im recording it using the macro tool , not the VBA module , pressing "end" and arrow down, the columns are fixed, but the quantity of rows, changes every time )

How could i do, to make it work with any selection , at any time? ( maybe some VBA code to do so? )

Hope i was clear...

Thanks in advance as ussual.

Pablo

 

[VoG]

Maybe like this

Range("A1").CurrentRegion.SpecialCells(xlCellTypeVisible).Copy