paste special whatever is on the clipboard

  • Thread starter Thread starter jrh
  • Start date Start date
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.
 
ActiveCell.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

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