Run time error 424

Hi All,

This script suddenly not working.Yesterday it was working with excel 2007, now am using with excel 2003.its throwing error ("Run time error 424").

Please Login or Register  to view this content.

Error!!!!!

("Run time error 424").


Poiting the line -> "cell.Interior.Color = XlRgbColor.rgbYellow"

could you pls help me to resolve it, only after solving this issue i can try the next code thhat you gave above

I don't think those constants are defined/available in Excel 2003.

In Excel 2007:

?xlrgbcolor.rgbRed
255
?xlrgbcolor.rgborange
42495
?xlrgbcolor.rgbgold
55295
?xlrgbcolor.rgbyellow
65535
?xlrgbcolor.rgblightyellow
14745599

You could try changing the values to those listed above. No guarantees though.

Regards