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