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

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

Hyperlink - Excel VBA programming

Reply to Message Icon

Original Message
Name: sforsasi
Date: August 18, 2008 at 12:49:50 Pacific
Subject: Hyperlink - Excel VBA programming
OS: XP
CPU/Ram: 1 GB
Model/Manufacturer: 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.


Report Offensive Message For Removal








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








Do you own an iPhone?

Yes
No, but soon
No


View Results

Poll Finishes In 6 Days.
Discuss in The Lounge
Poll History




Data Recovery Software