G
Guest
I am trying to syncronize two charts, but I am getting a "Run-time error
1004, method of axes of object failed" error.
I am getting this right out of a book to help me with vba, but this one
isn't working.
This is what I have:
Sub SynchronizeCharts()
Dim myWest As Chart
Dim myEast As Chart
Set myWest = ActiveSheet.ChartObjects("West").Chart
Set myEast = ActiveSheet.ChartObjects("East").Chart
myWest.Axes(x1value).MaximumScaleIsAuto = True
The line above is where I am getting the error. Can anyone tell me why?
TIA
1004, method of axes of object failed" error.
I am getting this right out of a book to help me with vba, but this one
isn't working.
This is what I have:
Sub SynchronizeCharts()
Dim myWest As Chart
Dim myEast As Chart
Set myWest = ActiveSheet.ChartObjects("West").Chart
Set myEast = ActiveSheet.ChartObjects("East").Chart
myWest.Axes(x1value).MaximumScaleIsAuto = True
The line above is where I am getting the error. Can anyone tell me why?
TIA