autofilter hides rows that don't meet the criteria, but the values ar
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)).Valu
-------------------
offsets will consider every row, even the ones that are hidden. i
there a way to make it so that it will consider only those rows tha
are shown?
thanks
--
dream
-----------------------------------------------------------------------
dreamz's Profile:
http://www.excelforum.com/member.php...fo&userid=2646
View this thread:
http://www.excelforum.com/showthread.php?threadid=53855