compile error with Find function

[maacmaac]

I am trying to use the Find function within some VBA code but keep encountering a compile error. Code works fine on it's own as below but doesn't work within the VBA code. I can't figure out what part of code needs to be modified. Thanks

The desired result in J2 = "Jim"

the value in cell I2 = "Jim |Anderson"

Working Function as follows:

Please Login or Register  to view this content.

VBA code

Please Login or Register  to view this content.

[shg]

Your are using Find as if it were a worksheet function. Look at at Help for the VBA InStr function.

[maacmaac]

Found what I was looking for and was able to figure it with a little trial and error. I appreciate you pointing me in a direction to figure out the answer on my own rather than giving me the code straight up.

Please Login or Register  to view this content.

[shg]

Good job, MM.