Name a Sheet through Macro

  • Thread starter Thread starter S. S.
  • Start date Start date
S

S. S.

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

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy cell value from one worksheet to matching worksheet in another workbook 4
Reference sheets named by DAY 7
Macro to Combine Data from Multiple Sheets with Cell References 4
Put data by matching cell value with sheet name 2
Copy adjacent Sheet and name from a list 42
Changing sheet name based on a cell in another sheet 1
Copy data into sheets 13
Run macro from active workbook whose name keeps changing 20

Back
Top