Hi Anita,

how many different currencies can be used within the local
sheets? If there are just a few possibilities, you can
search for them with the Find method... but that won't
make sense if there may be more than a few of them...

Like:

If Range("commentrange").Find(what:="Yen") Is Not Nothing
Then

..
..

Else

End If


HTH

Best

Markus



-----Original Message-----
Hi,

Monthly I have to convert comments from a local currency
sheet to a US
dollar sheet in an excel file. In the comments the local
currency is
often expressed. I need the value to be in US dollars
when it appears
on the US dollar sheet. Is there a way to search the
text to find the
local currency amounts and use a variable to convert that
to US dollars.

Thanks in advance for any help that you can provide. I'm
not betting
that I will get many answers to this one . . .

Regards,
Anita

.