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 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

[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

"BrianT" wrote:

>
> 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
>
>
> --
> BrianT
> ------------------------------------------------------------------------
> BrianT's Profile: http://www.excelforum.com/member.php...o&userid=35954
> View this thread: http://www.excelforum.com/showthread...hreadid=557551
>
>

[George Gee]

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

HTH

George Gee


"BrianT" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> BrianT
> ------------------------------------------------------------------------
> BrianT's Profile:
> http://www.excelforum.com/member.php...o&userid=35954
> View this thread: http://www.excelforum.com/showthread...hreadid=557551
>