Hi Again,

I need to figure out how I can find a substring within a string in VBA.
Say Col A, Row1 = cats, dogs, pigs

and I want to find cats and if possible know the position in the string.
If it occurs first then I need to count it otherwise I don't

I found find in the worksheet function, but I can't find it in VBA.
Also what is a good book that has all the VBA functions?

Thanks As Always! Kurt