JNW wrote:

I would actually not use VBA for what you explained. I would have the horses
listed in Column A, in column B I would type C, D, or CD and in column C I
would have the following formula:
=if(or(B1="C",B1="D"),10,if(B1="CD",20,0))

VBA is great stuff, but life is much easier when I don't try to reinvent the
wheel.

I will try that and let you know. Thanks!

--