is # instring

nada

Board Regular
Joined
Jul 4, 2006
Messages
193
Hi! IN my macro i get info from another program. if there is a problem then my macro will recieve a string that contains a #. How do I check a string to see if there is a # ? Thanks very much!!!
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

rjp

Board Regular
Joined
Jan 5, 2006
Messages
148
You can use the Instr function to see if there is a # at any point in the string:

Code:
InStr(1, "abc", "#")

returns 0

Code:
InStr(1, "a#bc", "#")

returns 2 as that's the position of the first occurence of a '#'.

So you can use:

Code:
If InStr(1, "abc", "#") = 0 Then
    <there's no error>
Else
    <there's an error>
End If

ps. the 1 means start searching at the 1st character in the string.
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,515
Something like this? Dave
Code:
Sub test()
Dim strtest As String, i As Integer
strtest = [sheet1!A1]
For i = 1 To Len(strtest)
  temp = Asc(Mid(strtest, i, 1))
  If temp = 35 Then
  MsgBox "Found #"
  Exit Sub
  End If
  Next i
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,109,486
Messages
5,529,152
Members
409,851
Latest member
Ingar
Top