VBA Excel 2007 : Autofit Merge Cells Error "Run-time error '13': Type Mismatch"

Hello -

I am desperately in need of your help because I can't seem to understand why the below script keeps giving me this error "Run-time error '13': Type Mismatch". The part with a red font is where the error is coming.

Can you please help me in figuring out what I did wrong?

Please Login or Register  to view this content.

Thank you very much!!!!

I'm not sure if I am on the right track here but .Text means nothing in that context. The .Text should equal = or <> something.

EDIT: That's definitely the problem.