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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying Macro Needed 2
VBA set thick borders around non empty cells in range 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Copy COUNTIF while retaining reference 7
copy cell only with contains 3
copy and paste (visual basic) 1
How can I automatically copy cell contents from one cell into anot 2
Copying a named range with a changing cell reference 1

Back
Top