VBA: Is there a way to tell what cell is the "frozen cell" where Freeze Panes was issued?

[TomCon]

Is there a way to find out what cell the Freeze Panes command was issued on? That is, what is the upper left cell of the bottom right quadrant in a window view with frozen panes?

What i really want to do is select that cell in a macro, that is, mimic what the Excel UI does when you do Ctl-Home in a window with frozen panes.

If you record a macro Excel does not do anything special to record Ctl-Home, it just records something like "Range("B2").Select", which of course is not usable in the general case, unless you could query what cell was selected when Freeze Panes was issued.

Thanks!

 

[Rick Rothstein]

Give this a try...

  With ActiveWindow.Panes(1).VisibleRange
    Cells(.Rows.Count + 1, .Columns.Count + 1).Select
  End With

 

[TomCon]

Give this a try...

  With ActiveWindow.Panes(1).VisibleRange
    Cells(.Rows.Count + 1, .Columns.Count + 1).Select
  End With

Thanks much....that does it indeed! Nice!