LinearGradient Object (Excel)
The LinearGradient object transitions through a series of colors in a linear manner along a specific angle.
Attempting to access a Gradient property of an Interior object that does not have an existing gradient fill will result in a Run Time Error. Be aware of the Interior.Pattern property before accessing the Gradient property.
If Interior.Pattern is changed from a gradient type to a non-gradient type, the Gradient object will populate with default values.
Some things to consider when working with LinearGradient objects