Help! What's wrong with this simple copy and paste
It worked for me with xl2000 when used as a Commandbutton
click event. However, I would suggest greatly simplifying
it by not doing all that selecting. Also forget the copy
and paste. Try this simple code instead:
Sheets("Inputs").Range("M1") = Sheets("Report").Range("D1")
-----Original Message-----
This copy and paste does not work with my userform,
however it directly copied out of a macro I did.
Any help will be appreciated!
Worksheets("Report").Range("D48").Select
Selection.Copy
Sheets("Inputs").Select
Range("M16").Select
Selection.PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
.
|