Hi Dave,

I tried your code and it does not seem to work. 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. Could this be why it is not
working ? The entire column is then copied and pasted back as just
values to get rid of the formula's.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***