Thanks Don
after "dLastZRowPopulated = Cells(Rows.Count, "z").End(xlUp).Row ",
dLastZRowPopulated =10101has so it went nowhere! The real sticker
is when in Z10101, on spreedsheet, hitting [Ctrl] + [Up arrow] takes me
to Z100, sounds like environment or format getting in the way?
--
Bird
------------------------------------------------------------------------
Bird's Profile:
http://www.excelforum.com/member.php...o&userid=24469
View this thread:
http://www.excelforum.com/showthread...hreadid=500390