Top of Screen

[StewartCooke]

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

 

[Andrew Poulsom]

Like this?

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

 

[StewartCooke]

Cheers, thanks for that. It seems to have worked on the examples I've used it on so far.

Stewart