Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink in excel vba
Hi all,
I was trying to create hyperlink to other sheet in excel I did it like that: Sheets(2).Activate Range("a2").Hyperlinks.Add Range("a2"), "", "Control list", , "List" but it doesn't work. Can U tell me what's wrong??? regards, sweet_dreams |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink in excel vba
You may also want to check if your named range "Control list" is valid.
If you were trying to link to a worksheet then it looks like this: Sheet1.Range("a2").Hyperlinks.Add Range("a2"), "", "MySheet!A1", "My Hyperlink" If you were trying to jump to a web page then use this: Sheet1.Range("a2").Hyperlinks.Add Range("a2"), "www.mypage.com", "", "My Hyperlink" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... | Excel Programming | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |