willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
I have a VBA code but a section of it I cannot seem to get to work. What I am trying to do is format the Axis Minimum Bound to a number referenced in Cell V1 and keep the Maximum as Auto.
Can anyone advise what I am doing wrong?
Can anyone advise what I am doing wrong?
VBA Code:
ActiveSheet.ChartObjects("Chart 3").Activate
ActiveChart.Axes(xlValue).Select
' this line:
ActiveChart.Axes(xlValue).MinimumScale = ActiveSheet.Range("V1").Value
Application.CommandBars("Format Object").Visible = False
Application.CutCopyMode = False
Range("A2").Select