Using Find/Replace to delete contents of cell

Originally Posted by richardeallen

Hi
Some one has supplied me with a macro (from this brilliant forum!) which appears to be stalling because before i run the macro i need to use find and replace to remove #N/A values from my data. the macro seems to require the cell to be empty which i dont think find and replace actually does completely unless i'm running it wrong.
Any ideas?

Cheers

Rich

Hi,

Could you post the macro?

---