disable conditional formatting

[carlslack]

Hi,

I am using VBA code to populate cells from a large list. These cell
affect worksheet functions with conditional formatting. However, thi
conditional formatting is leading to unacceptably slow performance.

Can conditional formatting be temporarily disabled (during cod
execution), then enabled (when the code has completed)?

I've tried toggling Application.ScreenUpdating, but this still doesn'
help.

Any suggestions?

Thanks in advance,
-C

 

[Tom Ogilvy]

have you tried
Application.Calculation = xlManual

' current code

Application.Calculation = xlAutomatic