Prev: Inserting a picture XL2003
Next: Display No Data in Pivot
From: Ross in Oz on 18 Feb 2010 17:31
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.

From: Gord Dibben on 18 Feb 2010 19:12
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

On Thu, 18 Feb 2010 14:31:01 -0800, Ross in Oz
<RossinOz(a)discussions.microsoft.com> wrote:

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

 | 
Pages: 1
Prev: Inserting a picture XL2003
Next: Display No Data in Pivot