| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent Cell modification when Excel is executed | Excel Discussion (Misc queries) | |||
| scrolling target cell to top of page after hyperlink | Excel Discussion (Misc queries) | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| Set 'target' for hyperlink | Excel Discussion (Misc queries) | |||
| When a cell is merely selected, executed an evaluation? | New Users to Excel | |||
Linear Mode
