Script for filling cells with specific color

**adygelber** · 10-11-2012, 03:31 AM

Hello,

I have a list of values in column B (beginning with row 7) and I am trying to clour them using the colour codes from column C, using the above script:

Please Login or Register  to view this content.

The columns looks like this:

B C
val1 6
val2 6
val3 6
val4 6
val5 6
val6 6
val7 6
val8 40
val9 40
val10 40
val11 40
val12 40
val13 40
val14 34
val15 34
val16 34

The problem is that the code works only for the first 12 cells and I don't understand why, because the code should search xlDown until finds empty cells.
Can anyone help me to solve this?

Thanks!

**stojko89** · 10-11-2012, 03:48 AM

try switching this part of the code:

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

**stojko89** · 10-11-2012, 03:50 AM

If this doesn't work then try

Please Login or Register  to view this content.

**adygelber** · 10-11-2012, 03:59 AM

I doesn't work...I am attaching the sample file to see better what is the problem.
Anyway, there are some activities and 2 columns for colour codes (one for color fill and one for text color) and the script must copy the activities in another cell and set the corresponding colors to them.