Count colourindex - VBA

Hi all,

I have some code i tried to put together but it doesnt seem to be working.

Can anyone see where im going wrong? Because when the colorindex IS equal to the values its not going to THEN

Please Login or Register  to view this content.

Hi wrightyrx7,
is it not going to the "then" while stepping through with F8 or because the final assignments are not working??

I a have seen experts on this forum differ on the results of your line

Please Login or Register  to view this content.

in terms of what "Sick" is defined as.

I haven't tried to execute the code as I don't have a sample workbook and am happy for experts to suggest the right solution so I can learn some better practices as well

Jmac1947

Hi guys,

I have found its was a problem with the data that was being copied over.

The colours were not in my colour palette.

Added them and now it works fine.

Thanks for looking at this for me.