is there a #?

[Guest]

In my macro I get info from another program. If something has gone wrong then
the charachter # is found in the info. How can I write a short test to see if
that charachter is found in the info given? please help! thanks!

 

[Guest]

You can use InStr() to test for the presence of a character in a string:

Sub pound_test()
Dim s As String
s = "1234#5678"
If InStr(1, s, "#") > 0 Then
MsgBox ("Pound found")
End If
End Sub

 

[Bob Phillips]

If the_value Like "*#*" Then
... error

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)