View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnUK JohnUK is offline
external usenet poster
 
Posts: 173
Default Looking for worksheet according to name in cell

Hi, Just a quickie (I hope)
I have a cell that has been given a range name (Reg_no) How can a Worksheet
be selected according to the info within the Ranged cell?
The workbook has many tabs, and what I want is a piece of code that will
take me to the tab with the same name that is within the Ranged cell.
Help greatly appreciated
John