|Excel Developer Reference|
Consider the following when you are working with LinearGradient objects:
|The ColorStops collection is maintained in sorted order by position. This means that if a gradient has two stops, at 0.0 pt and 1.0 pt, and a third stop is added at 0.5 pt, the new stop is added to the middle of the collection. Enumerating the positions in the collection will show 0.0 pt, 0.5 pt, and 1.0 pt. |
- If you try to access the Gradient property of an Interior object that does not have an existing gradient fill, a run-time error occurs. Be aware of the Interior.Pattern property before you access the Gradient property.
- If Interior.Pattern is changed from a gradient type to a non-gradient type, the Gradient object will be populated with default values.
The following example turns off the border for the chart area in embedded chart 1 on the worksheet named "Sheet1".
|Visual Basic for Applications|