paste special whatever is on the clipboard

J

jrh

Hi, I want to paste special as values whatever is on the
clipboard starting in the currently selected cell. From
using the macro recorder, I have the following but I
cannot get it to paste what is on the clipboard.

PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False


Thank you.
 
T

Tom Ogilvy

ActiveCell.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

I believe the clipboard would need to have a range type object.
 
Top