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
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