Excel.FillFormat.GradientVariant.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
FillFormat.GradientVariant property (Excel)	vbaxl10.chm115016	vbaxl10.chm115016	Excel.FillFormat.GradientVariant	00b43056-7d7e-4d5a-edb0-535062fda776	04/26/2019	medium

FillFormat.GradientVariant property (Excel)

Returns the shade variant for the specified fill as an integer value from 1 through 4. The values for this property correspond to the gradient variants (numbered from left to right and from top to bottom) on the Gradient tab in the Fill Effects dialog box. Read-only Long.

Syntax

expression.GradientVariant

expression A variable that represents a FillFormat object.

Remarks

This property is read-only. Use the OneColorGradient or TwoColorGradient method to set the gradient variant for the fill.

Example

This example sets the fill format for chart two to the same style used for chart one.

Set c1f = Charts(1).ChartArea.Fill 
If c1f.Type = msoFillGradient And _ 
 c1f.GradientColorType = msoGradientOneColor Then 
 With Charts(2).ChartArea.Fill 
 .Visible = True 
 .OneColorGradient c1f.GradientStyle, _ 
 c1f.GradientVariant, c1f.GradientDegree 
 End With 
End If

[!includeSupport and feedback]