Worksheets(2).Range("A1").Value2 = Worksheets(1).Name

--

HTH

Bob

"Akhil Goel" wrote in message
...
I am having multiple worksheets in an Excel file and now I want to use the
name of each worksheet in a new worksheet in the same file.

Is there a formula which can copy the name of worksheet into a Cell of
another worksheet