ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Placing the target cell after a hyperlink is executed (https://www.excelbanter.com/excel-programming/273249-placing-target-cell-after-hyperlink-executed.html)

Jon Rathbun

Placing the target cell after a hyperlink is executed
 
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

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?




Tom Ogilvy

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?





All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com