It sounds like the OP want so paste into that filtered range (and skip the
hidden rows)--just about the opposite of what you suggested.



NlCO wrote:

Yes, you can ! ! !
Try activating the autofilter in the desired column, and selecting the
(NonBlanks)
Then Select the entire column, Copy, and paste where you like, thats
all ! !

Saludos

NlCO

--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=397703

--

Dave Peterson