Maybe you should try it. If works base on the assumptions I stated.
Also,
you said you wanted to clear V to AB.

If you actually want to delete those rows, then post back.

--
Regards,
Tom Ogilvy


"Tempy" wrote in message
...

Hi Thom,

sorry i do not think i am explaining myself clearly; Column V has the
error #N/A in, column W has a number, column X has #N/A and Y has a
date
in. If V has the error #N/A then i must clear V, W, X and Y.

Hopefully that is clearer

Tempy

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