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?
|