Returning reference of frozen cell
I have a spreadsheet in which the Freeze Panes anchor may be set by a user.
I would like to know the cell location of where the freeze panes is,
without
selecting any cells. How do I write code to check this?
Ideally, what I'm trying to do is something like this:
x = ActiveWindow.FreezePanes.Row
y = ActiveWindow.FreezePanes.Column
...except that "ActiveWindow.FreezePanes.Row" and
"ActiveWindow.FreezePanes.Column" is not a valid expression.
Would appreciate any help! Thanks.
I have never played around with this stuff myself, but a search through the
help files yielded this... ActiveWindow.SplitRow and
ActiveWindow.SplitColumn. There was also mention of panes and this seemed to
yield something positive (but I am unsure of how many panes are possible in
total)...
ActiveWindow.Panes(ActiveWindow.Panes.Count).Scrol lRow
ActiveWindow.Panes(ActiveWindow.Panes.Count).Scrol lColumn
where the scrollable area seems to be in the highest numbered pane (hence my
use of the count property).
Hope this helps.
Rick
|