Range("A1").Select
if activeWindow.VisibleRange(1).row < 3 then

--
Regards,
Tom Ogilvy


"Pete at Sappi Fine Paper" wrote:

I have a spreadsheet in which the Freeze Panes anchor may or may not be in
the right place. How do I write code to check this? I need to put the code
in the selection_change code for the worksheet, so I don't want to unfreeze
and re-freeze every time I change a cell ... just if it is currently frozen
in the wrong place.

Ideally, what I'm trying to do is something like this:

If ActiveWindow.FreezePanes.Row = 1 Then

ActiveWindow.FreezePanes = False
Range("A2").Select
ActiveWindow.FreezePanes = True

End If

...except that "ActiveWindow.FreezePanes.Row" is not a valid expression.

Would appreciate any help! Thanks.

Pete