FIND function not defined in macro
 

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.

FIND function not defined in macro
 

FIND is a worksheet function. The VBA functions are INSTR() and INSTRREV()

"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.

FIND function not defined in macro
 

If you still want to use the FIND function, qualify it thus:

txt="Mps/Stpaul, MN ".

Application.Find(",", txt, 1)
or
WorkSheetFunction.Find(",", txt, 1)


David.


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=483349