What could cause this code to malfunction on the
“dLastZRowPopulated = Selection.End(xlUp).Row” in:

Sub Macro1()
Dim dLastZRowPopulated As Double
Application.Goto Reference:="R10101C26" ‘Z(101:105)
Range("Z10101").Select
dLastZRowPopulated = Selection.End(xlUp).Row
End Sub

This code presented in its simplest form, and results in
dLastZRowPopulated =100, however Z(101:Z105) are populated. Any
insights as to how Z(101:Z105) are ignored?

By the way it happens on the spreadsheet as well. When in Z10101,
hitting [Ctrl] + [Up arrow] takes me to Z100 !?!?


--
Bird
------------------------------------------------------------------------
Bird's Profile: http://www.excelforum.com/member.php...o&userid=24469
View this thread: http://www.excelforum.com/showthread...hreadid=500390