Blanks but not zero I am afraid. You could filter on 0 and delete visible
rows.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Graham Y" wrote in message
...
Hi
Sheet1 has 30K links to another file, I copy the values to Sheet2 so I can
then delete those I don't want. I want to delete all those with a value of
0.