AboveAverage.ModifyAppliesToRange(Range) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Sets the cell range to which this formatting rule applies.

public:
 void ModifyAppliesToRange(Microsoft::Office::Interop::Excel::Range ^ Range);

public void ModifyAppliesToRange (Microsoft.Office.Interop.Excel.Range Range);

Parameters

Range: Range

The range to which this formatting rule will be applied.

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.

Applies to