Thread: Using an array formula as a hyperlink cell reference
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Using an array formula as a hyperlink cell reference
Hi Travis

First update the array formula to put a # in front of it:

="#" & your_formula

If the above is in cell A1, then

=HYPERLINK(A1)
will produce a nice, clickable, hyperlink
--
Gary''s Student - gsnu2007k
Reply With QuoteReply With Quote