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

--
carlslac
-----------------------------------------------------------------------
carlslack's Profile: http://www.excelforum.com/member.php...nfo&userid=524
View this thread: http://www.excelforum.com/showthread.php?threadid=26519