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.

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

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