"Paste formula" macro

[Denise]

I have created a customized toolbar that includes all of the editing and data manipulation tools I use most, except one: paste formula. The "paste formula" function is not available through the customize toolbar menu, and when I tried to record a macro for the function I get an error.

Does anyone know how I can create a macro (and ultimately toolbar button) for this?

Thanks.

Denise

 

[Juan Pablo González]

Sub Test()
Set Rng1 = Range("A1")
Set Rng2 = Range("A2")
Rng2.Formula = Rng1.Formula
End Sub