is there a function i could use to find all the "™‚" characters in a
worksheet? a standard search does not work as excel returns an error messages
saying it can't find the data we're searching for

Look for chr(63) ......

With Worksheets(1).Range("a1:a500")
Set c = .Find(Chr(63), LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
MsgBox c.Address
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address < firstAddress
End If
End With

End Sub


HTH
"davids" wrote:

is there a function i could use to find all the "™‚" characters in a
worksheet? a standard search does not work as excel returns an error messages
saying it can't find the data we're searching for

If the character is a question mark(?), then use ~?.

The question mark is a wild card. The tilde in front tells excel to really look
for that question mark character.

davids wrote:

is there a function i could use to find all the "™‚" characters in a
worksheet? a standard search does not work as excel returns an error messages
saying it can't find the data we're searching for

--

Dave Peterson