Thread: Find???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lolly[_2_] Lolly[_2_] is offline
external usenet poster
 
Posts: 28
Default Find???

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