How can I look for a sub-string within a string in VBA and...
 

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

How can I look for a sub-string within a string in VBA and...
 

checkout InStr() in VBA Help.
--
Gary's Student


"k. moran" wrote:

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