reset value in a column

Pleae can anyone advise me how to set reset a value to nothing
depending on its current value using VBA.

I have an excel column called 'New?' if the value is 'Y' I want to
return it to null.
Any help would be appreciated,
Redge

Hi Redog6

Try:

'=============>>
Public Sub Tester001()
Range("New").Replace What:="Y", _
Replacement:="", _
LookAt:=xlWhole, _
MatchCase:=False
End Sub
'<<=============

---
Regards,
Norman



<[email protected]> wrote in message
news:[email protected]...
> Pleae can anyone advise me how to set reset a value to nothing
> depending on its current value using VBA.
>
> I have an excel column called 'New?' if the value is 'Y' I want to
> return it to null.
> Any help would be appreciated,
> Redge
>

Many thanks Norman - that worked fine - Redge