Share via


ColorScale.ModifyAppliesToRange Method

Sets the cell range to which this formatting rule applies.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub ModifyAppliesToRange ( _
    Range As Range _
)
'Usage
Dim instance As ColorScale
Dim Range As Range

instance.ModifyAppliesToRange(Range)
void ModifyAppliesToRange(
    Range Range
)

Parameters

Remarks

The range must be in the A1 reference style and be entirely contained within the sheet that is the parent of the FormatConditions collection. It can include the range operator (a colon), the intersection operator (a space), or the union operator (a comma). Dollar signs can also be used but they are ignored.

You can also use a local defined name in any part of the range, but the name must be in the language of the macro.

See Also

Reference

ColorScale Interface

ColorScale Members

Microsoft.Office.Interop.Excel Namespace