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