| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
| Importing Long String - String Manipulation (EDI EANCOM 96a) | Excel Programming | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Create a formula into a String then assign string to a cell | Excel Programming | |||
Linear Mode
