Paste Formula

[Ross in Oz]

How can I put a "Paste Formula" command on to the toolbar similar to the
"Paste Formatting" and "Paste Values"

Having to go to Past Special and select it every time is a pain.

 

[Gord Dibben]

There is no such Icon.

You would have to use a macro assigned to a button.

Sub Paste_Formulas()
Selection.PasteSpecial Paste:=xlPasteFormulas
Application.CutCopyMode = False
End Sub

Select a range and copy.

Select a destination cell then hit button to run macro.

No error-checking in macro.


Gord Dibben MS Excel MVP