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