Top of Screen

StewartCooke

New Member
Joined
Mar 3, 2002
Messages
48
Hi

Does anyone know the most efficient way (in VBA) to set various points on a spreadsheet, such that, that point becomes the top left of the viewable area.

Thanks
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Like this?

Code:
Sub Test()
    Application.Goto Reference:=Range("G43"), Scroll:=True
End Sub
 

StewartCooke

New Member
Joined
Mar 3, 2002
Messages
48
Cheers, thanks for that. It seems to have worked on the examples I've used it on so far.

Stewart
 

Watch MrExcel Video

Forum statistics

Threads
1,113,800
Messages
5,544,347
Members
410,605
Latest member
hinspate
Top