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!
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!
Copyright © 2021 Jogjafile Inc.
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.