Update all charts instead of a specific one via macro

[ethaneandethaneproducts]

I have a macro that's designed to change the minimum and maximum axis values for a chart based on values entered in a cell. Example below

    ActiveSheet.ChartObjects("Chart 32").Chart.Axes(xlCategory).MinimumScale = Range("C2").Value
    ActiveSheet.ChartObjects("Chart 32").Chart.Axes(xlCategory).MaximumScale = Range("C3").Value

Rather than calling upon "Chart 32", I'd like to just update all charts on the active sheet (there are a lot). How would I go about this?

Thank you

 

[Domenic]

Try the following...

    Dim chrtObj As ChartObject
    
    For Each chrtObj In ActiveSheet.ChartObjects
        With chrtObj.Chart.Axes(xlCategory)
            .MinimumScale = Range("C2").Value
            .MaximumScale = Range("C3").Value
        End With
    Next chrtObj

Hope this helps!

 

[ethaneandethaneproducts]

Try the following...

    Dim chrtObj As ChartObject
   
    For Each chrtObj In ActiveSheet.ChartObjects
        With chrtObj.Chart.Axes(xlCategory)
            .MinimumScale = Range("C2").Value
            .MaximumScale = Range("C3").Value
        End With
    Next chrtObj

Hope this helps!

Worked perfectly, thank you! Any particular reason why you include the Dim chtO as ChartObject line? Could you just do For Each ChartObject in ActiveSheet.ChartObjects...?

 

[Domenic]

Worked perfectly, thank you!

You're very welcome!

Any particular reason why you include the Dim chtO as ChartObject line?

It's good practice to declare all your variables. I always place at the very top of any module the statement Option Explicit, which forces all variables to be declared. And it also helps to catch any spelling mistakes.

Could you just do For Each ChartObject in ActiveSheet.ChartObjects...?

Since ChartObject is actually an object type, it's best to avoid it.

 

[ethaneandethaneproducts]

You're very welcome!

It's good practice to declare all your variables. I always place at the very top of any module the statement Option Explicit, which forces all variables to be declared. And it also helps to catch any spelling mistakes.

Since ChartObject is actually an object type, it's best to avoid it.

Interesting. I'm learning VBA as I come across reasons to use it, so I appreciate the explanation.