clear range with conditional formating takes ages

[amigos.pl]

so I have a range of 2000 cells

they all have 2 conditional formats (both using functions referencing different cells)

I written some VBA to clear those cells and it takes ages

I tried

.FormatConditions.Delete
.Clear
.ClearFormats
.Rows.Delete

nothing speeds it up

calculation is manual
enable events = false

I just run out of ideas....

any suggestions?

thank you in advance

 

[baitmaster]

Can you post the rest of the code... E.g. are you looking at each cell in turn, or treating them as a single continuous range?

 

[amigos.pl]

forgot to add it: all that clearing attempts are done on 1 continous range

but I just tried application.screenupdate=false...and it worked

oldest trick always works

cheers!

 

[Ruddles]

.FormatConditions.Delete
.Clear
.ClearFormats
.Rows.Delete

.ClearContents