Thread: Paste special
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heine Heine is offline
external usenet poster
 
Posts: 49
Default Paste special

Hello everybody

I want to create a paste special button. My VBA is not as strong,
though.

ActiveCell.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

I thought this little bit of code would do the trick. But it fails.

Any ideas?