ColorStops.Add Method (Excel)
Adds a ColorStop object to the specified collection.
Version Information
Version Added: Excel 2007
Syntax
expression .Add(Position)
expression An expression that returns a ColorStops object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Position |
Required |
Double |
Represents the position in which to apply the ColorStop. |
Return Value
ColorStop
Example
Adds a ColorStop for the active selection.
Range("A1:A10").Select
With Selection.Interior.Gradient.ColorStop.Add(1)
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0
End With