I'm trying to label a chart axis with this ...
Set objAxis = xlapp.ActiveChart.Axes(xlValue, xlPrimary)
With objAxis
.HasTitle = True
.Title.Text = "Issues"
End With
And I keep getting a Unable to get the Axis property of the Chart class, Code 800A03EC.
Does anyone haev any idea what I'm missing here?
TIA,
JohnCR
Set objAxis = xlapp.ActiveChart.Axes(xlValue, xlPrimary)
With objAxis
.HasTitle = True
.Title.Text = "Issues"
End With
And I keep getting a Unable to get the Axis property of the Chart class, Code 800A03EC.
Does anyone haev any idea what I'm missing here?
TIA,
JohnCR