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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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,118,656
Messages
5,573,431
Members
412,529
Latest member
cTatch
Top