Colours in Comments

[AlexanderBB]

Hi, I want to log what colours are used in various comments in a worksheet and was using
the command

= .Characters(1, 5).Font.Color (I think this gives the color of the first 5 chars and a Null if they're not the same . Is that right ?)

(Don't ask what goes before the first "." I tried to find out here here and never got a reply)

Anyway, it was all going well until suddenly it throws up 74. From Googling around the highest number expected was 56.

The actual color is black, or dark grey.

1) What woud it give an "outside-range" number (if that's what it is) ?
2) Is there list to be found that shows what number > 56 mean?

Thanks !!!

 

[Michael M]

I'm afraid I can't offer any further advise.
Never had a need to worry about the colour number ...

 

[Michael M]

Would it help if you returned the RGB for ALL cells instead ??
If so , have a look here

Determining the RGB Value of a Color (Microsoft Excel)

 

[AlexanderBB]

Would it help if you returned the RGB for ALL cells instead ??
If so , have a look here

Determining the RGB Value of a Color (Microsoft Excel)

If not convinced it would help, and although I haven't tried yet I don't see it correcting this '74' to the
right number to further process. Strange sort of problem this... pity no guru has offered any ideas. Might be worth
a question on Stack Overflow. BTW I did ran same routine on Excel 2007 and its results were different but also wrong. In Excel 2003
.color and .colorindex are the same. In 2007 they're not. .color is different, mostly its 0 but has also been a big number like 16711680. I didn't try to figure out why to preserve sanity!

But thanks for bouncing ideas and if I get any further I'll let you know.
Cheers, ABB