Not using that approach.

Regards,
Tom Ogilvy



"dreamz" wrote:


autofilter hides rows that don't meet the criteria, but the values are
still there. however, when i use code like:


Code:
--------------------
NumIn = InputBox.Value
Range(Range("AF1"), Range("AF1").Offset(NumIn - 1, 0)).Value = Range(Range("A366"), Range("A366").Offset(NumIn - 1, 0)).Value
--------------------


offsets will consider every row, even the ones that are hidden. is
there a way to make it so that it will consider only those rows that
are shown?

thanks.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=538556