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.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=512581