Paste Value

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am trying to copy cells O12:O25 and paste the value in cells U12:U25. The
problem is that I need to only paste the value of cells that have a number
in it on not the cells that have a value of "#N/A". I also have the same
problem in a different place but the value that I do not want to copy is
"#VALUE!".

Thanks
 
If you go back a step, you should look at the reason why
some cells contain #N/A and #VALUE. You can use worksheet
formulas (see ISERR and ISERROR) to ensure these do not
appear in your data. Then you will only see values.
 
Back
Top