I am using the following code to change the charts in the sheet "DashBoardOne". I want to include the sheet "DashBoardTwo" in the code. Can someone please advise how I change line 3 to include the additional sheet?
Thanks in advance.![]()
Sub ColumnCharts() Application.ScreenUpdating = False Dim Cht As ChartObject For Each Cht In Sheets("DashBoardOne").ChartObjects Cht.Chart.ChartType = xlColumnClustered Next Cht End Sub
Bookmarks