ColorStop.TintAndShade Property

  • Article
Excel Developer Reference

Returns or sets the tint and shade of the represented object. Read/write

Version Information
 Version Added:  Excel 2007

Syntax

expression.TintAndShade

expression   A variable that represents a ColorStop object.

Return Value
Variant

Remarks

Example
Applies tint and shade to 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