Paste Formula

  • Thread starter Thread starter Ross in Oz
  • Start date Start date
R

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.
 
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
 
Back
Top