Paste values whilst ignoring formulas.

[Jay07]

Hi all

Is it possible to highlight a range of cells (all of which contai
formulas), copy and paste as values but ignoring all formulas that ar
currently showing as #REF

 

[Spencer101]

Hi all

Is it possible to highlight a range of cells (all of which contai
formulas), copy and paste as values but ignoring all formulas that ar
currently showing as #REF!

Hi,

I think this is one of those cases where it's better to cure the proble
at the root than cover up the result.

What is causing the #REF! error