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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting SubStrings and thier starting positions within Main Strin 2
Help with Replace() 11
Delete rows based on contents of Col A 0
Efficient way of finding string and changing cell value 4
find and scroll to cell string value in Excel 2
Separating parts of a string in VBA 4
selecting cells and getting their content into a string? 1
Parse a space delimited string into unique columns 1

Back
Top