Hi,
1. Does it break on the
WorksheetFunction.Find
or on something else such as the Left/Right vba functions?
2. could you please post some of your code?

--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"AC" wrote:

I am using the FIND function to find a character in a text string. I have to
find the state (CA, MA) etc and have a text string "Mps/Stpaul, MN ".
So if I can find the "," I can use the "Right/Left" function to determine
the state. The help says that this function exists but the compiler is
giving me an error message.