Arcturus16a
New Member
- Joined
- Jul 24, 2019
- Messages
- 4
I would like to create a macro that allows me to paste values of something copied from one range to another.
The macro should paste from the clipboard any copied range from any source (another sheet or workbook) and should paste those values into (starting at) a user-selected range.
I thought this would work, but Error msg 1004 indicates that the Paste Special method of Range has failed. What can I do to make this work?
Sub PasteValue()
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub
The macro should paste from the clipboard any copied range from any source (another sheet or workbook) and should paste those values into (starting at) a user-selected range.
I thought this would work, but Error msg 1004 indicates that the Paste Special method of Range has failed. What can I do to make this work?
Sub PasteValue()
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub