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



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