Copying cells

[BrianT]

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 cel
contents to another sheet and while the cells controlled by macro
copied the info the ones controlled by formulas returned ####ref

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

 

[kassie]

Copy as usual (<Ctrl><C>), move to the new sheet, click where you want to
paste, right click, select Paste Special, select Values and OK out will do it
for you

 

[George Gee]

Copy the cells, select the destination, right-click
Paste special > Values.

HTH

George Gee