It is probably the AutoScaleFont property that threw the error. It is
normally used with Boolean value of True or False. Try using just Font.

"Tom" wrote:

I have a bunch of charts embedded in a worksheet and I am trying to change
the font size on the axis using vb.

My code is:


For iChart = 1 To nCharts

With ActiveSheet.ChartObjects(iChart).Axes(xlCategory)
.TickLabels.AutoScaleFont.Size = 9
End With

However I get an error: object does not support this property or method