Paste special formulas button

[arwol]

I want to create a button on my toolbar for pasting (only) formulas.
Does anyone have an idea??

Thanks!

 

[Atholl]

Try this:

Sub Paste_Special()

Selection.PasteSpecial Paste:=xlFormulas, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub

You'll have to create a custom button on your menu and assign this code to it. Also, this assumes that you've already cut or copied something to the clipboard..

Atholl

 

[arwol]

It is working!!
thanks!