Macros to Paste Values from Clipboard|VBA & Macros|Excel Forum|My Online Training Hub

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?

Sub PasteValue()
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub