Hi,
I am using a macro to cut a single cell from 15 rows of a column of a worksheet and then pasting the data into another 15 cells in another worksheet.
The macro appears to work perfectly, except that if I filter the initial worksheet the macro still copies the first 15 rows of the worksheet NOT the first 15 filtered rows......
the "offending" line of script currently is:
Range("A1:A15").Select
Help, please.
Bookmarks