FormatCondition.ModifyAppliesToRange method (Excel)
Sets the cell range to which this formatting rule applies.
Syntax
expression.ModifyAppliesToRange (Range)
expression A variable that represents a FormatCondition object.
Parameters
Name | Required/Optional | Data type | Description |
---|---|---|---|
Range | Required | 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.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort beschikbaar: In de loop van 2024 zullen we GitHub-problemen geleidelijk uitfaseren als het feedbackmechanisme voor inhoud en deze vervangen door een nieuw feedbacksysteem. Zie voor meer informatie:Feedback verzenden en weergeven voor