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.

Accepting that there is probably a better way to do this, can I use
SpecialCells to find all those cells with 0 in and then delete them?

TIA

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.

Hi

SpecialCells to find all those cells with 0 in and then delete them?
No

See this page for a other examples
http://www.rondebruin.nl/delete.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"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.

Accepting that there is probably a better way to do this, can I use
SpecialCells to find all those cells with 0 in and then delete them?

TIA