Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reference to cell with text is returning #VALUE | Excel Discussion (Misc queries) | |||
Cell reference returning incorrect value | Excel Discussion (Misc queries) | |||
Returning the cell reference when you find a value in an array | Excel Worksheet Functions | |||
Returning a cell reference with a formula? | Excel Worksheet Functions | |||
Returning with cell on right/left of a reference | Excel Worksheet Functions |