Do you mean that you determine the #N/A in column V, then clear V-AB,
regardless of whether those other columns have a #N/A in that row?

The code I gave goes through each column one at a time.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tempy" wrote in message
...

Sorry, thats columns V to AB

Tempy

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