vba search for other language

R

rmanchu

hi

i'm searching excel for some text typed in word using vba.

it works in english, but not when the text is in the language i'm
working on. its DI named Divehi in the windows language settings
environment.

DI is a complex, right to left writing language.

has any had problems with other languages when using vba search?

please help

thanx
riyaz
 
R

rmanchu

for info:

i've solved it. when using other languages, do NOT convert to strings
(such using the CStr function)

always use the Variant type

seems to work for me

riyaz
 
Top