paste special whatever is on the clipboard
 

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.

paste special whatever is on the clipboard
 

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

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

--
Regards,
Tom Ogilvy


"jrh" wrote in message
...
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.