Dim X as long
dim Y as long
With ActiveWindow.Panes(4)
Y = .ScrollColumn
X = .ScrollRow
End With




GilesT wrote:

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.

--

Dave Peterson