ClearCircles Method

Applies To

Worksheet object.

Description

Clears circles from invalid entries on the worksheet.

Syntax

expression.ClearCircles

expression Required. An expression that returns a Worksheet object.

Remarks

Use the CircleInvalid method to circle cells that contain invalid data.

See Also

Add method (Validation object), CircleInvalid method.

Example

This example clears circles from invalid entries on worksheet one.

Worksheets(1).ClearCircles