Using VBA to change axis on a chart

Hi all,

I'm trying to use VBA to adjust the axis of a chart, setting a MIN and MAX value and an axis value for the vertical axis crosses. My code is as follows

Sub Macro2()
'
' Macro2 Macro

    ActiveSheet.ChartObjects("Chart 18").Activate
    ActiveChart.Axes(xlValue).Select
    ActiveChart.Axes(xlValue).MinimumScale = Range("F9").Value
    ActiveChart.Axes(xlValue).MaximumScale = Range("F8").Value
    ActiveChart.Axes(xlValue).CrossesAt = Range("D5").Value
    
End Sub

With this code, I can see the values change in the command bar however it is not applying the change to the chart? My chart is called Chart 18

Picture1.jpg

Many Thanks

The name of my chart was incorrect (lol)
Sorry. Thanks for the suggestion!!!