| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning reference of frozen cell
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference to cell with text is returning #VALUE | Excel Discussion (Misc queries) | |||
| Cell reference returning incorrect value | Excel Discussion (Misc queries) | |||
| Returning reference of frozen cell | Excel Programming | |||
| Returning a cell reference with a formula? | Excel Worksheet Functions | |||
| Returning with cell on right/left of a reference | Excel Worksheet Functions | |||
Threaded Mode
