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!
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!