CrossesAt VBA Run-time error

[prk2022]

Can someone let me know why this is giving an error at .Axes(xlValue).CrossesAt = 0?


Sub Macro2()
ActiveSheet.ChartObjects("Chart 1").Activate
With ActiveChart
.Axes(xlValue).CrossesAt = 0
.Axes(xlCategory).CrossesAt = 0
End With
End Sub


Thanks

 

[Leith Ross]

Hello prk2022,

According to the VBA Help Files...

[TABLE="width: 100%"]
<tbody>[TR]
[TD="align: left"]Excel Developer Reference[/TD]
[/TR]
[TR]
[TD="align: left"]Axis.CrossesAt Property[/TD]
[/TR]
</tbody>[/TABLE]
Returns or sets the point on the value axis where the category axis crosses it. Applies only to the value axis. Read/write Double.