Slow Case Select code

Hi Folks

I have really slowly executing code for a Select Case. Its referencing a named range hower when I referenced a set block (the same size as the named range) it was just as slow.

All its doing is conditional formating a cell on the value of a cell 4 columns to the right.

Please Login or Register  to view this content.

any suggestions?
Cheers
Kranky

Thanks gents

Tried the switching screen updating and calcs off and on afterwards. No gains. We're talking about a dozen seconds.

Holger, yes the code needs to run as it then sets the colour for the appropriate ranges pie chart.

So the run of the code is:
Create pie chart from range that all have the same value. Colour the range cells (as above) then the pie segments are coloured to the source cell. The last part doesn't work if the range cells are conditional formated.

I use similar code in another book however it references specific cells and in a set range. The range I'm trying to work on currently will grow every day, the previous range never and the code was instantaneous..

Thanks again

Kranky

Thanks snb

Code runs till line 21 then gets application or object defined error

Please Login or Register  to view this content.

So far

Please Login or Register  to view this content.

Cheers
Kranky