Worksheet.ClearCircles Method (Excel)

Clears circles from invalid entries on the worksheet.

expression .ClearCircles

expression A variable that represents a Worksheet object.

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

This example clears circles from invalid entries on worksheet one.

Worksheets(1).ClearCircles
Show:
© 2014 Microsoft