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.

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.

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.

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.

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 -