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

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

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,767
Messages
5,574,126
Members
412,573
Latest member
Chriszion
Top