Version Information
Version Added: Excel

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.

Visual Basic for Applications 
Range("A1:A10").Select With Selection.Interior.Gradient.ColorStop.Add(1) .ThemeColor = xlThemeColorAccent1 .TintAndShade = 0 End With

See also: