Computing.Net > Forums > Programming > Hyperlink - Excel VBA programming

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Hyperlink - Excel VBA programming

Reply to Message Icon

Name: sforsasi
Date: August 18, 2008 at 12:49:50 Pacific
OS: XP
CPU/Ram: 1 GB
Product: Windows
Comment:

I would like to add a hyperlink to Sheet1 referencing a cell in Sheet2. How do I do it via VBA macro?

The below doesn't seem to work. Any help would be appreciated.

Sheets(Sheet1).Hyperlinks.Add Anchor:=Sheet1.Cells(1, 1), Address:="", SubAddress:=Sheet2.Cells(5, 1).Address(rowabsolute:=False, columnabsolute:=False)

Skumar.



Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Hyperlink - Excel VBA programming

VBA Programming for Excel www.computing.net/answers/programming/vba-programming-for-excel/9207.html

Excel VBA Problem saving file www.computing.net/answers/programming/excel-vba-problem-saving-file-/14722.html

Excel/VBA 98 on Mac www.computing.net/answers/programming/excelvba-98-on-mac/7303.html