View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cathy[_5_] Cathy[_5_] is offline
external usenet poster
 
Posts: 3
Default Refer to Hyperlink

How can I refer to the hyperlink information of a cell?

Lets say cell A1 contains text "website"
but the hyperlink refers to "http://www.website.com"

I would like for cell B1 to only show the hyperlink information of
cell A1

Any help will be appreciate

TIA