Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ThisWorkbook.FollowHyperlink to Location in Workbook
I can get the following to work in a VBA sub:
ThisWorkbook.FollowHyperlink Address:="http://example.microsoft.com" but get an error when I try to specify a location in the workbook with: ThisWorkbook.FollowHyperlink Address:="", SubAddress:="Sheet1!A3" It seemed that would be the proper format for the address in the open workbook, but I'm picking up an error - "Run time error 5 - Invalid procedure call or argument" What am I missing or doing wrong here? I really need to do this programatically and not have to define a "fixed" hyperlink on the worksheet (or anywhere else). Thanks in advance for any help you can give! James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to workbook location | Excel Worksheet Functions | |||
FollowHyperlink to OLEObject | Excel Programming | |||
FollowHyperlink | Excel Programming | |||
followhyperlink | Excel Programming | |||
followhyperlink failure | Excel Programming |