How do I find "?" character in a column using VBA?

[Raju]

I have some numerical data in a excel worksheet which is downloaded from
another application. By mistake in some of the fields some non numberical
characters(Ex: "?") are entered. I want to eliminate "?" character using VBA.
Please help.

[Bob Phillips]

Columns("E:E").Replace What:="~?", _
Replacement:="", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False, _
SearchFormat:=False, _
ReplaceFormat:=False


--
HTH

Bob Phillips

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

"Raju" <[email protected]> wrote in message
news:[email protected]...
> I have some numerical data in a excel worksheet which is downloaded from
> another application. By mistake in some of the fields some non numberical
> characters(Ex: "?") are entered. I want to eliminate "?" character using
VBA.
> Please help.

[Norman Jones]

Hi Raju,

Try:

'=============>>
Public Sub Tester()
Dim rng As Range

Set rng = ActiveSheet.UsedRange '<<==== CHANGE

rng.Replace What:="~?", _
Replacement:="", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False

End Sub
'<<=============


---
Regards,
Norman


"Raju" <[email protected]> wrote in message
news:[email protected]...
>I have some numerical data in a excel worksheet which is downloaded from
> another application. By mistake in some of the fields some non numberical
> characters(Ex: "?") are entered. I want to eliminate "?" character using
> VBA.
> Please help.