Name a Sheet through Macro

[S. S.]

How can a sheet name be reassigned to match the value of a
cell in that sheet?

 

[Chip Pearson]

Try something like

Worksheets(1).Name = Range("A1").Value

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[S. S.]

Chip,

I had that and it did not seem to work. I think it is
having issues because there is no value in "A1".
I think my line to put a value in A1 is incorrect:
(Worksheets(2).Range("A1").Value = Pdate) where Pdate is a
string.

Am I not setting this up correctly?

Forgive me inexperience with VB.

Thank you.

S.