create link to another 'place in this document'
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. -- Using multiple environs but usually: Office 2007 on WinXP Pro SP3 |
create link to another 'place in this document'
Hi,
Maybe this ActiveSheet.Hyperlinks.Add Anchor:=Range("A1"), Address:="", _ SubAddress:="Sheet3!A1", TextToDisplay:="MyText" Mike "herefroggy" wrote: 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. -- Using multiple environs but usually: Office 2007 on WinXP Pro SP3 |
create link to another 'place in this document'
Well are you clever. ;)
Thanks for the undocumented feature. -- Using multiple environs but usually: Office 2007 on WinXP Pro SP3 |
All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com