Determine which row is active below freeze pane
 

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.

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.

Determine which row is active below freeze pane
 

Here is another way...

MsgBox ActiveWindow.Panes(ActiveWindow.Panes.Count).Scrol lRow

This can be made "neater" if we don't insist on doing it in one line...

With ActiveWindow.Panes
MsgBox .Item(.Count).ScrollRow
End With

--
Rick (MVP - Excel)


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.

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.

Determine which row is active below freeze pane
 

Thank you both - I almost had it and then saw your posts.

On Sep 28, 10:39*pm, "Rick Rothstein"
wrote:
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.- Hide quoted text -

- Show quoted text -