View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete at Sappi Fine Paper Pete at Sappi Fine Paper is offline
external usenet poster
 
Posts: 23
Default Returning reference of frozen cell

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