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.