referring to a column by letter, not number

Your code worked fine and I learned something new today. However it still didn't solve my final problem. I needed to use the referrence to the column in a formula. The formula I'm trying to use looks like:

Please Login or Register  to view this content.

where colid is my variable column that I determined earlier in the code.
The formula is suppose to determine the first 3 characters from the string in colid, look for them in column B of Sheet "Make" and return the value from column A, Sheet Make and write it in the active column in sheet1. In column B sheet Make I have something like: "MKJ HGF LBV THD YVX". I can have only 2 or 3 groups of characters separated by space, or I can have any number of groups.

When I try to run the macro I get the message: "application-defined or object -defined error" (error # 1004).