Chinese Characters and VBA
 

I've written a piece of Excel VBA code which includes searching for °C
(degrees centigrade) in some of the code. I'm now trying to get this
code to work on a colleagues computer who is from China. His version
of Excel changes the °C into a Chinese character in VBA. This causes
the macro to fall over.

Does anyone have any ideas how to force VBA to use English characters
by default?

Thanks for any and all assistance!