| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access connection works in Macro, not in user-defined Function | Excel Programming | |||
| Macro user defined function row information | Excel Programming | |||
| User Defined Function used in Macro returns #VALUE | Excel Programming | |||
| Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming | |||
| Find size of array passed to user-defined function | Excel Programming | |||
Linear Mode
