View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Placing the target cell after a hyperlink is executed

Guessing what you mean by "hyperlinking"

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

Regards,
Tom Ogilvy

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?