Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If I have a named range called MyCell, and I go there with Application.Goto
reference:="MyCell", I would like to have the Sheet scroll this range to the top of the Window. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can probably calculate how to scroll the window based on the location of
the upper-left cell of "MyCell", but I did it by: ActiveCell.SpecialCells(xlLastCell).Select Selection.End(xlDown).Select Selection.End(xlToRight).Select Application.Goto "MyCell" "akyhne" wrote: If I have a named range called MyCell, and I go there with Application.Goto reference:="MyCell", I would like to have the Sheet scroll this range to the top of the Window. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW IS COLUMN "K" REFERENCED ON THE CURRENT ROW IN THE GOTO COMMAN | Excel Discussion (Misc queries) | |||
Custom Data Validation : Lock if MyCell = ""? | Excel Worksheet Functions | |||
Excel VBA - go to worksheet "name" based on a cell reference ="Name" | Excel Programming | |||
'Application.Goto Reference | Excel Programming |