BigB,
I'm not a VB user, but assuming that the syntax is similar in Excel formulas, shouldn't the IF statement have an ending parenthesis at the end of the line (and 1 less after 'False')? If it is correct as you entered, please respond so that I'll know better as I venture into VB.