Syntax Issue with Pasteing Xlvalues

[BIGTONE559]

I have code and i can get it into the proper area however, i cannot paste the values.

I normally use Range(blah).copy
range(blah).pastespecial xlvalues

however that did not work in this case.

Code is Below:

Range(Cells(cell.Row, 1), Cells(cell.Row, 3)).Copy Destination:=Sheets("BCresolve").Cells(destrow, 1)

 

[njimack]

Don't think you should be using Cells(cell.Row - you probably want something like
Range(Cells(CopyRow,1),Cells(CopyRow,3))

 

[BIGTONE559]

i added copyRow as a long value. However, i still need assistance pasting the values after i copy. . .