MinorTickMark Property Example
This example sets the minor tick marks for the value axis in Chart1 to be inside the axis.
Charts("Chart1").Axes(xlValue).MinorTickMark = xlTickMarkInside