disable conditional formatting
 

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

disable conditional formatting
 

have you tried
Application.Calculation = xlManual

' current code

Application.Calculation = xlAutomatic

--
Regards,
Tom Ogilvy


"carlslack" wrote in message
...

Hi,

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

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

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

Any suggestions?

Thanks in advance,
-CS


--
carlslack
------------------------------------------------------------------------
carlslack's Profile:
http://www.excelforum.com/member.php...fo&userid=5248
View this thread: http://www.excelforum.com/showthread...hreadid=265192