change tab name

C

Chip Pearson

Dave,

Try something like

Worksheets("OldTabName").Name = "NewTabName"


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

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

Worksheet functions in VBA 2
Disable Range Selection Change 3
Browser Functions Problem 7
FreezePanes on a Row without using an ActiveWindow object 1
How can I store both key and value in VBA? 1
Calculate time 6
Range missing its target area weirdly 5
How to add entries in the Menue bar with VBA code? 1

Top