View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Jay07 View Post
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!
Hi,

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

What is causing the #REF! error?