| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a Hyperlink to A Cell that References a Worksheet
I'd like to programatically apply a hyperlink to an active cell that will
point to a named range on another sheet in the same workbook. I haven't had any luck with the following code: ******** Set sh = Worksheets("Dashboard") sh.Activate sh.Cells(p + 5, 2).Value = arrENGINE(i) sh.Cells(p + 5, 2).Select sh.Cells(p + 5, 2).Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:=arrENGINE(i) _ , TextToDisplay:=Selection.Value ******* where arrENGINE(i) is a string - example "GF44-123PL_G01" Any suggestions as to what is going on? -- Thanks! Max |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning a Worksheet Name to a Cell | Excel Worksheet Functions | |||
| Hyperlink cell references | Excel Worksheet Functions | |||
| Assigning macro to a hyperlink | Excel Worksheet Functions | |||
| Assigning a Hyperlink to a CommandButton | Excel Discussion (Misc queries) | |||
| Assigning a Hyperlink to a Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
