Hi all,
I apologise for the delay, time difference, below is an example; I need
to sort by #N/A which was a formula, but copyied and then pasted as
special-values only. I then need to clear the cells v to AB ONLY as all
the other cells in the same row have data that i require

V W X Y Z AA AB

2163254 11 01 18-Apr-05 J N
#N/A 11 #N/A 21-Jan-04
2078426 11 01 18-Mar-05 J J
2078427 11 01 10-Jan-05 J J
2077697 11 01 03-Mar-05 J J
2028870 11 01 23-Mar-05 J J
1933445 11 01 14-Dec-04 J J

Hopefully this will help

Tempy

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