Hi all!!
I'm after renaming all charts in Workbook. But i want the names to be the combinations of 3 things - 1st variable, "." , and 2nd variable. The code i use is
The bold line is not allowed use of code. What is the right way of doing this? Thanks in advance!!![]()
Sub Renaming_charts() Dim ws As Worksheet Dim c Dim b As Integer For Each ws In ActiveWorkbook.Worksheets b = 1 For Each c In ws.ChartObjects c.Name = ws&"."&b b = b + 1 Next Next End Sub
Bookmarks