Thread: Use cell value as reference to sheet in formula?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bluegnu bluegnu is offline
external usenet poster
  
Posts: 1
Default Use cell value as reference to sheet in formula?

OK, I've been using this loads, but now I've tried to using nested in
the Hyperlink function. I did this:

=HYPERLINK(INDIRECT(A1&"!C3"),INDIRECT(A1&"!C3"))

Now the friendly name bit works OK, but the hyperlink doesn't. Is it
possible to create a hyperlink using this method?

thanks


--
bluegnu
------------------------------------------------------------------------
bluegnu's Profile: http://www.excelforum.com/member.php...o&userid=36108
View this thread: http://www.excelforum.com/showthread...hreadid=558830

Reply With QuoteReply With Quote