ClearCircles Method [Excel 2003 VBA Language Reference]

  • Article

Clears circles from invalid entries on the worksheet.

expression**.ClearCircles**

expression Required. An expression that returns a Worksheet object.

Remarks

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

Example

This example clears circles from invalid entries on worksheet one.

Worksheets(1).ClearCircles

Applies to | Worksheet Object

See Also | CircleInvalid Method