For Each Colored Cell Macro

[hack4u]

I've been working on changing up a code that I have been using and it worked perfectly fine to pull data from the range I was creating. I'm trying to search a specific range, for a 9 digit number that has a specific Interior Color and list it in Column B. Here is what I have (with the If statement I placed in there it stopped working).

Please Login or Register  to view this content.

Any help is appreciated

[walruseggman]

If you're using an RGB value, then you want .Color, not .ColorIndex

[hack4u]

You know I didn't even think about that :P

Works fine now. Thanks a bunch!

[walruseggman]

Great, don't forget to mark this thread SOLVED