Placing the target cell after a hyperlink is executed

[Jon Rathbun]

When "hyperlinking" to a given cell (with a macro, not
with a true hyperlink), how can you "place" the cell you
hyperlink to in the top left corner of the worksheet area?

 

[Donald Lloyd]

Try

Application.Goto Reference:=Sheets(1).Cells(10,10) ,Scroll:=True

Sheets(1).cells(10,10) used as an example - replace as necessary.
Please note the colon before the = sign

Regards,
Don

 

[Tom Ogilvy]

Guessing what you mean by "hyperlinking"

Application.Goto Reference:=Worksheets("sheet1").Range("Z29"), Scroll:=True

Regards,
Tom Ogilvy