Naming Charts
Dear Experts:
below code snippet is supposed to name Charts in the following syntax:
MyChart_01
MyChart_02
MyChart_03
etc.
The 'format'-part of the code is obviously not correct. How do I have change the code so that the charts are correctly named?
With myChtObj.Chart.Parent
.Name = Format("MyChart_" & i + 1, "_##")
End With
i = i + 1
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
below code snippet is supposed to name Charts in the following syntax:
MyChart_01
MyChart_02
MyChart_03
etc.
The 'format'-part of the code is obviously not correct. How do I have change the code so that the charts are correctly named?
With myChtObj.Chart.Parent
.Name = Format("MyChart_" & i + 1, "_##")
End With
i = i + 1
Help is much appreciated. Thank you very much in advance.
Regards, Andreas
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Brad:
ok, great, this works just fine. Thank you very much for your professional help.
Teylyn, I am awarding 50 points to you since the syntax of the code snippet is correct. Thank you very much.
Regards, Andreas
ok, great, this works just fine. Thank you very much for your professional help.
Teylyn, I am awarding 50 points to you since the syntax of the code snippet is correct. Thank you very much.
Regards, Andreas
ASKER
thank you very much for your swift support. I am off to lunch and will get back to you afterwards.
Regards, Andreas