Never had this before but how do I do it?

I have a range of cells say A1 to D10, I tried to copy the cell contents to another sheet and while the cells controlled by macros copied the info the ones controlled by formulas returned ####ref

How do I just copy the cell contents? my line manager only needs the figures in the cells so doesn't need to see my attempts at making them look better