View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Donald Lloyd Donald Lloyd is offline
external usenet poster
 
Posts: 30
Default Placing the target cell after a hyperlink is executed

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

"Jon Rathbun" wrote in message
...
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?