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 ***