April 2006
Beginner
1114 pages
98h 16m
English
axis.MajorGridlines
Returns the Gridlines object of the axis. For example, the following code selects the category axis major gridlines if they exist:
Sub SelectGridlines( )
Dim chrt As Chart, gl As Gridlines
Set chrt = ActiveChart
chrt.ChartType = xl3DArea
If chrt.Axes(xlCategory, xlPrimary).HasMajorGridlines Then
Set gl = chrt.Axes(xlCategory, xlPrimary).MajorGridlines
gl.Select
End If
End SubRead now
Unlock full access