Delete conditional formatting from a sheet

[j4ymf]

Hello All

How would I delete conditional formatting from a sheet?
im getting an error ??
Thank you

  'delete conditional formatting on all cells
    With Sheets("JANUARY").Range("A1:AH")
        .FormatConditions.Delete
    End With

 

[SpillerBD]

? "A1:AH"
shouldn't that be more consistent like "A:AH"

 

[SpillerBD]

Hello All

How would I delete conditional formatting from a sheet?
im getting an error ??
Thank you

  'delete conditional formatting on all cells
    With Sheets("JANUARY").Range("A1:AH")
        .FormatConditions.Delete
    End With

With Sheets("JANUARY").Cells
         .FormatConditions.Delete
     End With