How to copy cells content only
One way without using copy:
Sheets(2).Range("B5") = Sheets(1).Range("D10").Value
Using copy:
Sheets(1).Range("D10").Copy
Sheets(2).Range("B5").PasteSpecial Paste:=xlPasteValues
"cgnotrom" wrote:
Using 2007 Excell and trying to send data to a child sheet
Currently I am getting the Formula and Colors and Borders.
I only want the Value result of the formula to be copyed to the next sheet,
not the Formula.
example of a command I am using;
Set lg = Sheets("mine").Cells(6,13).Resize(1,3)
tryed to enter the statement Type:=xlFillWithContents
but the debugger didn't like me.
Please help !
|