Thread: Creating Hyperlink in excel 2003 VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
davesexcel[_42_] davesexcel[_42_] is offline
external usenet poster
  
Posts: 1
Default Creating Hyperlink in excel 2003 VBA

=HYPERLINK("#Sheet3!A1","Sheet2!A1") this takes you to Sheet3 A1 and
will label where you are going
=HYPERLINK("#Sheet3!A1",A2) this will take you to sheet 3 A1 but the
cell will have the value of A2 of whatever sheet you have this formula
in


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519659

Reply With QuoteReply With Quote