Name a Sheet through Macro

C

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. 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.
 
Top