Generate automatically name of the sheets

76 Views Asked by At

Is it possible to generate automatically the name of the sheet? For example I want to name the sheets in the following way:

"chart1", "chart2", "chart3"..

Thanks!

1

There are 1 best solutions below

0
On BEST ANSWER

The Worksheet.Name property can be used to change the name of the worksheet in VBA.

This can be either done when creating new sheets, or set afterwards with the Worksheets(x).Name, where x is either the name of the worksheet you want to change, or an index.

For more information you can check the MSDN page about Worksheets.