Hi

Try this

worksheets("Inputs").range("M16").value = _
worksheets("Report").range("D48").value

libby

-----Original Message-----
I am trying to do a simple copy and paste in my userform
and it keeps giving me an error. Here is my code. I am
using it, to paste current values as past values for the
next user. Here is my current code.


Worksheets("Report").Range("D48").Select
Selection.Copy
Sheets("Inputs").Select
Range("M16").Select
Selection.PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Thanks
.