SpecialCells help

[Guest]

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

 

[Bob Phillips]

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)

 

[Ron de Bruin]

Hi
No

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

 

[Dave Peterson]

If you don't have any errors in that copy|pasted range, you could edit|replace 0
with =na(), then use specialcells looking for errors in your code.