This doesn't affect you, but it's interesting that I found one time that if I want to color a row I can't use the vbBlue constant. I found that I needed to use 16711681 instead which is just one off of vbBlue's value.