|What version did you upgrade from?|
I have found that while using VBA to set/determine the fill color of cells, some of the ColorIndex numbers didn't match between the 2 versions.
For example, in 2003 I filled C3 with Green, making sure I chose the Green that popped up "Green" when I hovered over the color in the dialog box - in other words, not Sea Green or Dark Green, just Green.
When I ran this code, it returned 10:
When I did the same thing in 2010, again making sure I chose Green, the code returned 14, which tells me that the Green in 2003 is different than the Green in 2010.
In fact, when I saved the 2003 workbook and opened it in 2010, I couldn't find a matching Green in the Find/Replace dialog box.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.