January 13, 2022
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 code (below) would work, but Error msg 1004 indicates that the Paste Special method of Range has failed. What can I do to make this work?
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013