below code snippet is supposed to name Charts in the following syntax:
The 'format'-part of the code is obviously not correct. How do I have change the code so that the charts are correctly named?
.Name = Format("MyChart_" & i + 1, "_##")
i = i + 1
Help is much appreciated. Thank you very much in advance.