View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
kwiklearner
 
Posts: n/a
Default How do I name a group of cells?


1 Define the group of cells by: InsertNameDefine
2 Create a name for the group of cells, in the refers to box, indicate
location of your group of cells.
3 Select cell where you want to put the hyperlink
4 InsertHyperlink
5 Select Place in this document
6 Select the named range under Defined Names
Hope this helps



barronka Wrote:
I am trying to set up a hyperlink on one worksheet in a workbook that
will
point to and highlight a group of cells in another worksheet in that
same
workbook. I am using Excel 2003.



--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=520600