Get the Hyperlink address form a cell

**plans** · 11-23-2022, 03:50 PM

Hello,
I am trying this script:

msgbox activecell.hyperlinks(1).address

Could you please advise what is the correct code?
Thanks

**plans** · 11-23-2022, 04:47 PM

The value in the active cell is hyperlinked to a worksheet in the same active workbook.
I am trying to extract the worksheet name of the place where the hyperlink is directed.

**vichopalacios** · 11-24-2022, 11:13 AM

When the link is to the same book, you use SubAddress

MsgBox ActiveCell.Hyperlinks(1).SubAddress

**plans** · 11-24-2022, 01:00 PM

Thank You, it worked!

**vichopalacios** · 11-24-2022, 05:29 PM

Glad to know it helped you,
thanks for the reps !!

Get the Hyperlink address form a cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Get the Hyperlink address form a cell

Re: Get the Hyperlink address form a cell

Re: Get the Hyperlink address form a cell

Re: Get the Hyperlink address form a cell

Re: Get the Hyperlink address form a cell

Thread Information

Users Browsing this Thread

Similar Threads

Database form that can capture file address and save to cell in hyperlink format

[SOLVED] Making a cell address as a hyperlink to it...

[SOLVED] To Add Hyperlink to cell address

[SOLVED] Cell address as text to hyperlink

[SOLVED] User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell

Hyperlink & cell address

hyperlink with cell value as part of address

Bookmarks

Bookmarks

Posting Permissions