Menu
I have a conditional that doesn't seem to work.
If Not InStr(1, cell.Value, "-") Then
'Do Something
Else
'Do something else
End If
Where cell.Value are either numbers in a spreadsheet with a dash: "6621-123", or without a dash: "555321"
The first If let's both through and the Else is ignored. Any ideas why this isn't working?
812
The syntax of VBA InStr is “InStr([start],string1,string2,[compare]).” In comparison, the syntax of InStrRev is “InStrRev(string1,string2,[start,[compare]]).” If the “start” argument is omitted, the InStr begins to search from the starting (first position) of the string.
The INSTR function returns a numeric value. The first position in string is 1. If substring is not found in string, then the INSTR function will return 0.
The InStrB function is used with byte data contained in a string. Instead of returning the character position of the first occurrence of one string within another, InStrB returns the byte position.
INSTR Function Using VBA to Find String in a Cell You can find any string and its position from any cell. The VBA InStr Function indicates if a text string is detected in another text string. It returns 0 if the text is not found. Otherwise, it returns the character position where the text is located.
InStr returns 0 on no match (not -1 as VBA string indexes are 1 based)
and not 0 is true (-1); so are all other possible values > 0 that can be returned.
If InStr(1, cell.Value, "-") = 0 Then
'// not present
Else
'// present
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
