create link to another 'place in this document'

H

herefroggy

The function I want is the same as if you select a cell, right mouse, select
Hyperlink... and then choose "Place in this document".

The Hyperlinks.Add method does not have a type and the link created appears
to be external only.

I thought about just copying an existing cell with such a link already
created and changing the Address but ... the Address property is EMPTY for
these types of links.

At a loss.
 
M

Mike H

Hi,

Maybe this

ActiveSheet.Hyperlinks.Add Anchor:=Range("A1"), Address:="", _
SubAddress:="Sheet3!A1", TextToDisplay:="MyText"

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ThisWorkbook.Close crashing Excel (2010) 11
Hyperlink to a Particular Cell ---- but allowing flexibility to add new rows and still keep the link 3
macro to open a document 6
Create a web site link from a part link and a data field in access 2003 1
trying to create a link to a link in Excel (2007) 3
Insert Hyperlink -> Place in This Document 9
Check for valid file before hyperlinking 4
HELP! 6

Top