I would say your description of your problem in response to Dave's solution
is so incomprehensible and lacking detail that your chances of an answer are
very small.

The clearer your explanation of what you are trying to do, the more likely
you are to receive assistance. Based on your first posting in this thread,
Dave's solution is quite adequate. Your response

>What i did omit to say
>is that the the 0 is a result od a Vlookup, findine the lookup value on
>both sheets but the required field is empty.

Who knows what the "required field" is or the significance of it being
empty. Vlookup works on one range. How does it result in a zero for
finding the "lookup" value on "both sheets". In any event, that should be
immaterial. Dave's code loops through column V and clears cells where a
cell in column V has a numeric value of zero or a 1. Again, it should be
immaterial how that value is produced, even if you have replaced the formula
in the cell with the value it displayed.

It is unclear why you say it doesn't work.

--
Regards,
To Ogilvy


"Tempy" <anonymous@devdex.com> wrote in message
news:%23MmKMMHYFHA.3572@TK2MSFTNGP12.phx.gbl...
> Help please !!!
> This is really frustrating me, gonna go home and have a beer !!
> Speak again in the morning.
>
> Regards
>
> Tempy
>
> *** Sent via Developersdex http://www.developersdex.com ***