I didn't bother quoting everything, just one addendum.

I was mistaken when I said it was copying all the rows when I filtered.
It is only copying the visible range (the rest of the data was there
from before I filtered).

So basically, I would like to copy the entire range (not just what is
visible) when it is filtered by some criteria.

Any ideas?

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=573831