Thread: is there a #?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!