Thread: Hyperlinks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham F
 
Posts: n/a
Default Hyperlinks

I need to make a hyperlink year independant, I want to concatenate a string,
place it in a cell and access that from VBA. I thought this instruction might
be useful, Worksheets(1).Range("E16").Hyperlinks.Item(1).Foll ow but of course
the concatenated string is not a hyperlink. Any help & advice would be
appreciated. As you might guess I am new to this. Many thanks Graham