| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning reference of frozen cell
I agree with you.
"Rick Rothstein (MVP - VB)" wrote: Dim X as long dim Y as long With ActiveWindow.Panes(4) Y = .ScrollColumn X = .ScrollRow End With From my quick experiment with this "pane" stuff, I concluded using the hard-coded 4 might fail if the spreadsheet were only split at the columns only or the rows only (there would only be 2 panes then). My solution, applied to your setup would be something like this... Dim X as long Dim Y as long Dim MaxPane as Long MaxPane = ActiveWindow.Panes.Count With ActiveWindow.Panes(MaxPane) Y = .ScrollColumn X = .ScrollRow End With Rick -- Dave Peterson |
| 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
