Axis.MajorTickMark procedure builder

Axis.MajorTickMark (Excel)

Returns or sets the type of major tick mark for the specified axis.

xlTickMarkCross - Crosses the axis, xlTickMarkInside - Inside the axis, xlTickMarkNone - No mark, xlTickMarkOutside - Outside the axis.

XlTickMark can be one of the XlTickMark constants.

ActiveChart.Axes(1).MajorTickMark = xlTickMarkCross