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!

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!

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

--
HTH

Bob Phillips

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

"Arne Hegefors" wrote in message
...
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!