How would I change a chart's scale with VBA? Right now I have the following:

    ActiveSheet.ChartObjects("Chart 7").Activate
    ActiveChart.Axes(xlValue).MinimumScale = price_chart_min
    ActiveChart.Axes(xlValue).MaximumScale = price_chart_max
and would like to do this without excel physically selecting the chart (first line of code, but have it simply change the value of max and min.

Thank you.