Review this post.

http://www.mvps.org/dmcritchie/excel/colors.htm

If this post helps click Yes
---------------
Jacob Skaria


"MAX" wrote:

I am trying to get some colour numbers so that I will use them in codes. I am
using Excel 2007 and I tried to get the number of the red colour by record a
macro then I look in module. So for red it gives me number 255. When I
inserted in code, it didn't work. Just to tell you that in Excel 2003 it
gives me number 3, and it worked.
The problem is that I have Excel 2007. Any help please?

Thanks a lot