Placing the target cell after a hyperlink is executed

  • Thread starter Thread starter Jon Rathbun
  • Start date Start date
J

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?
 
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
 
Guessing what you mean by "hyperlinking"

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

Regards,
Tom Ogilvy
 
Back
Top