Hello,
I've just started to use excel 2007 after 2003 usage (pain). It seems that the colour palette has changed. which is causing me problems.
My issue is that the bright red (formerly 36) is no longer on the standard colours and the red that looks a lot like it is number -16776961
The macro that I had created will not change a cell's colour if it is red (36), so obvioulsy does not recognise any cells coloured in the new palette numbering. When I try to get it to recognise -16776961, the macro just skips the line.
Can I either get the 2007 excel to recognise -16776961 in the macro, or get it to just call the red number 36 instead of -16776961 ?
The particular part of code that doesn't seem to be working is
Please Login or Register to view this content.
In my macro, I also reference other 2003 colours which also have a similar problem (blues, maroon, grey)...is there a simple fix?
I hope this is clear, but please let me know if I need to explain it again
Thanks
Bookmarks