Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search within a single cell for a character
Using VBA I want an If/Then statement to search within a single cell (D59) to
find if the ":" (colon character) exists after the fourth character. If not "Then: Wrong = True" In an adjacent worksheet cell I could just enter =iserr(find(":",D59,4)) and if the result is True then I know it doesn't exist. How do I write this in VBA? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace a single character WITH FORMAT in a cell | Excel Worksheet Functions | |||
Character Search a cell | Excel Worksheet Functions | |||
Limit the input in a cell to a single character | Excel Programming | |||
How do I perfom a character count in a single cell in Excel? | New Users to Excel | |||
Case sensitive and single character in cell | Excel Programming |