ColorStop.ThemeColor Property (Excel)
Returns or sets the theme color of the represented object. Read/write
Version Information
Version Added: Excel 2007
Syntax
expression .ThemeColor
expression A variable that represents a ColorStop object.
Return Value
Long
Example
Applies theme color to the active selection.
Range("A1:A10").Select
With Selection.Interior.Gradient.ColorStop.Add(1)
.ThemeColor = xlThemeColorAccent1
.TintAndShade = 0
End With