"Paste formula" macro

Denise · Feb 20th, 2002, 09:59 AM

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 · Feb 20th, 2002, 10:01 AM

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

Feb 20th, 2002, 10:01 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Sub Test() Set Rng1 = Range("A1") Set Rng2 = Range("A2") Rng2.Formula = Rng1.Formula End Sub __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 09:59 AM	#1
Denise New Member Join Date: Feb 2002 Location: M&T Bank Posts: 18	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