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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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,119,241
Messages
5,576,906
Members
412,753
Latest member
Coach_Olson
Top