View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Shailesh Shah[_2_] Shailesh Shah[_2_] is offline
external usenet poster
 
Posts: 114
Default How do I display the link location of a hyperlink?

See VBA help for Hyperlink.

e.g. Range("A1").Hyperlinks(1).Address


Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdex http://www.developersdex.com ***