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.
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.