Delete all FormtaConditions with VBA

[HectorManuel]

Help. I need to remove all FormatConditions in a Worksheet. There are 12 FormatConditions over several ranges and selecting each range and then deleting each one (Selection.FormtConditions.Delete) would be too cumbersome.

However, neither of the following alternatives seem to work:

ThisWorkbook.Sheets(1).Cells.FormatConditions.Delete

For i = 1 to ThisworkBook.Sheets(1).Cells.FormatConditions.Count
ThisWorkbook.Sheets(1).Cells.FormatConditions.Item(i).Delete 'I've also tried ThisWorkbook.Sheets(1).Cells.FormatConditions(i).Delete
Next

I keep getting a 'Application-defined or Object-defined error' message.

Any idea?

 

[shg]

Welcome to the board.

Cells.SpecialCells(xlCellTypeAllFormatConditions).FormatConditions.Delete

You could do the same thing from the UI.

 

[belkacem]

Good evening

Sub Delete_All_FormatConditions()


' if you want to delete All FormatConditions in All sheets
Dim SH As Worksheet
For Each SH In Sheets
SH.Cells.FormatConditions.Delete
Next




End Sub


**************************************************************************


Sub Del_FC_In_Sheets()


'if you want to delete All FormatConditions in single sheets named : Sheet1
Sheets("Sheet1").Cells.FormatConditions.Delete


End Sub