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