Have looked into this a bit but do not see how to determine on which cell the panes are frozen if FreezePanes=True for a particular worksheet.
The ActiveWindow seems to have a SplitRow and SplitColumn property, but that is for Split Panes not FreezePanes.
The ActiveWindow.Pane has a VisibleRange property, but this depends on where the pane is scrolled to and does not necessarily indicate the intersecting cell of the panes.
What i want to find out is the cell that will be selected if you were to hit Ctl-Home in the user interface. But, this is recorded as something like Range("A2"). Select. In other words, I do not see a way to duplicate the behavior of Ctl-Home in code.
Any help with this? "how to find the cell at which the FreezePanes command was originally done on a worksheet" (in order to duplicate it elsewhere in code).
The ActiveWindow seems to have a SplitRow and SplitColumn property, but that is for Split Panes not FreezePanes.
The ActiveWindow.Pane has a VisibleRange property, but this depends on where the pane is scrolled to and does not necessarily indicate the intersecting cell of the panes.
What i want to find out is the cell that will be selected if you were to hit Ctl-Home in the user interface. But, this is recorded as something like Range("A2"). Select. In other words, I do not see a way to duplicate the behavior of Ctl-Home in code.
Any help with this? "how to find the cell at which the FreezePanes command was originally done on a worksheet" (in order to duplicate it elsewhere in code).