ExcelBanter - change tab name

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - change tab name (https://www.excelbanter.com/excel-programming/308113-change-tab-name.html)

Chip Pearson

change tab name

Dave,

Try something like

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

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

"dave!!" wrote in message
...
how can i change the name of a tab with code?

dave!!

change tab name

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

All times are GMT +1. The time now is 07:37 PM.