Thread: Determine which row is active below freeze pane
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Determine which row is active below freeze pane

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.

Reply With QuoteReply With Quote