is there a #?
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
--
Gary's Student
"Arne Hegefors" wrote:
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!
|