Posted to microsoft.public.excel.programming
|
|
Determine which row is active below freeze pane
It appears that your method can be simplified even more...
MsgBox ActiveWindow.VisibleRange(1).Row
--
Rick (MVP - Excel)
"Don Guillett" wrote in message
...
Try this
MsgBox ActiveWindow.VisibleRange.Resize(1, 1).Row
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
wrote in message
...
Hi ...
Is there a way to determine what the active row is immediately below
the freeze pane (frozen row)? I think that there must be but I can't
seem to find anything on that.
|