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