View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
maijik maijik is offline
external usenet poster
 
Posts: 1
Default how do I insert a cell value in a hyperlink formula

I need to insert a value from another cell in the same spreadsheet say B2 to
replace nnnnnn in the following hyperlink and have tried &B2, "B2","&B2&"
!B2, =B2, nothing seems to work. Any ideas? Thanks in advance.

http://domweb21.bank.net/apps/ecms/C...&Annnnnn&ANorm