p. 34, Procedure "PrintRGBValues", in ISBN 0-596-00728-0, appears to be missing some lines of code. There don't seem to be any statements that place color # n in a cell, and then assign that color's color to variable name strRGBVal. The variable strHexVal isn't defined anywhere, either. Thanks.
Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I'm Curtis Frye, the author. I apologize for the code error...it appears that there was a bad cut-and-paste during editing and I didn't catch it when I reviewed the galley proofs.
A hard drive crash wiped out my original code, but fellow MVP David McRitchie has a similar routine on his site at http://www.mvps.org/dmcritchie/excel/... . I no longer have any versions prior to Excel 2007 installed on my computer, but his code ran for me in 2007.
Thanks for letting me know about the error. I hope this fix gives you the information you need.