There is no need to cross post. The level of responder expertise at MRExcel
is quite capable of providing a solution and has.
If Possible with Formulas
This is not possible using formulas.
--
Biff
Microsoft Excel MVP
"Hardeep Kanwar" wrote in message
...
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