G
GilesT
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 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.