rrosa1
07-17-2010, 02:19 PM
hi
how to paste only value since there r some fuction in cells
With ws
If .Name <> "Report" Then
.Range("A1:C1").Copy Destination:=Sheets("Month Total").Range("A" & Rows.Count).End(xlUp).Offset(1) _
.Range("A1:C1").PasteSpecial xlPasteValues
End If
End With
this code give me the run time error 1004
"past-special method of range class failed"
thanks for any help
how to paste only value since there r some fuction in cells
With ws
If .Name <> "Report" Then
.Range("A1:C1").Copy Destination:=Sheets("Month Total").Range("A" & Rows.Count).End(xlUp).Offset(1) _
.Range("A1:C1").PasteSpecial xlPasteValues
End If
End With
this code give me the run time error 1004
"past-special method of range class failed"
thanks for any help