Cannot find range in Sub Colour_coding script

I have attached a report which contains a colour coding script was written by an ex colleague. The problem is when running the macro it stops at line 89. I have had to extend this list beyond line 89. I cannot find the "range" within the VBA which identifies what the range selected should be. spent hours trying to work it out and am now stumped.


Before anyone suggests I use conditional formatting, this has to work on Excel 2003 which sadly is limited to 3 conditions.

Hi, MakkyD,

the last loop starts with

Please Login or Register  to view this content.

You should try using a more specific way in getting the last row and then use a For lngRow = 44 to LngLR

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger