Look for value in a column and delete
 

Hi Bob,

Thanks yes that is correct, if column V has #N/A in it then i must clear

cells V - AB in that row. In other words if the filter 22 filters for
#N/A all exposed cells in V-AB only must be cleared. All other cells in
other columns must not be affected.

Thanks for the help Bob.

Tempy

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