![]() |
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? |
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? |
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