is # instring

[nada]

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!!!

 

[rjp]

You can use the Instr function to see if there is a # at any point in the string:

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

returns 0

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

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

So you can use:

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]

Something like this? Dave

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