Hi all

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