Copying cells

  • Thread starter Thread starter BrianT
  • Start date Start date
B

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;
 
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
 
Copy the cells, select the destination, right-click
Paste special > Values.

HTH

George Gee
 
Back
Top