Hi,
In excel sheet there is a character like this.
MIDLLE �計
the occurence of this character is many times in the sheet. I need to use a
find comand in excel VBA. Here is my code

Set rng1 = Range("A:B").Find(What:="MIDLLE �計", _


When I paste the above mentioned code in the Visual Basic editor
it changes like this
Set rng1 = Range("A:B").Find(What:="MIDLLE ??", .....

Any help on this would be highly appreciated.
Thanks in advance.
--
Kittie

I am Chinese. It is no problem when I paste the mentioned code in the
Visual Basic editor. I think that your Excel can't support Chinese. So
you can download some Excel Chinese support software


Aheng

hi,

your OS should have japanese support.

If you are using WindowsXP
Goto Control PanelRegional SettingLanguage Tab
On the Language tab click detail button and Goto to Advanced tab
then check tha Extend support of advanced text services to all
programs.

if your OS doesnt have japanese support it will ask
you to insert the OS CD.

Hope this will help