I wouldn't see it ever working.

--
Regards,
Tom Ogilvy

"dreamz" wrote in
message ...

hmm, thanks. i'll try that.

i came up with something like this:

Range(Range("AF1"), Range("AF1").Offset(NumIn - 1, 0)).Value =
Range("A366:A727").SpecialCells(xlCellTypeVisible) .Value

in other words, range AF1 to AFx, where x depends on the number that
was entered, and the values of the visible cells. that worked in a
dummy file i came up with, but for some reason, it doesn't work in the
workbook i'm using (it just repeats the first item in the list).


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