View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hardeep kanwar Hardeep kanwar is offline
external usenet poster
 
Posts: 65
Default Give a sheet name from a Cell

Hi! Experts

http://www.mrexcel.com/forum/showthread.php?t=403613

Is it possible to give a Name to a Sheet from a Cell.

Assuming in Column A i have Sheets Names

Worksheets
CZ001
CZ002
CZ003
CZ004
CZ006
CZ007
CZ008
CZ009
CZ012
CZ014
CZ015
CZ016
CZ017



Now i want to give the Name to every Sheets depending on these Cells

Sheet1= CZ001, Sheet2= CZ002 and so on.

If Possible with Formulas otherwise Macro or Code will be Secondly Options
for me.

Coz, sometimes i have to work on other Systems or Computers.

So, its not Possible person like me who is totally stupid in Macros to use
Codes

So, thats why i always Prefers Formulas not Macros or Codes or VBA

Thanks in Advance

Hardeep kanwar