change tab name

[Chip Pearson]

Dave,

Try something like

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


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

 

[dave!!]

how can i change the name of a tab with code?