adding to a macro

tealeaf · May 20th, 2002, 12:13 PM

Once i've stopped recording a macro, how do i record more on the same one? ie: i want to continue doing stuff in Excel and i want those new steps to be recorded in an already existing macro.

Rocky E · May 20th, 2002, 12:17 PM

Most recorded macros require atleast some editing anyway. Record a the second half in a seperate macro and the edit the two back in to a single macro. Very common technique.

texasalynn · May 20th, 2002, 12:37 PM

This is great and is exactly what I want to do, but I'm not getting how to put them together. Could you give an example.

tealeaf · May 20th, 2002, 12:39 PM

my rather primitif way of doing it is just copy-paste one into the other...any better suggestions anyone?

Nimrod · May 20th, 2002, 12:58 PM

Thats the only way I'm aware of doing it...ie. tools --macro--edit--cut and paste OR select sheet tab -- rt click-- view code--select module-- cut and paste

May 20th, 2002, 12:17 PM	#2
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Most recorded macros require atleast some editing anyway. Record a the second half in a seperate macro and the edit the two back in to a single macro. Very common technique. __________________ Hope this helps! Rocky <h6>"Be not the first by whom the New are try'd, Nor yet the last to lay the Old aside." Alexander Pope (1688-1744).</h6>

May 20th, 2002, 12:58 PM	#5
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Thats the only way I'm aware of doing it...ie. tools --macro--edit--cut and paste OR select sheet tab -- rt click-- view code--select module-- cut and paste __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

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

May 20th, 2002, 12:13 PM	#1
tealeaf Board Regular Join Date: May 2002 Location: mtl, canada Posts: 160	Once i've stopped recording a macro, how do i record more on the same one? ie: i want to continue doing stuff in Excel and i want those new steps to be recorded in an already existing macro.

May 20th, 2002, 12:37 PM	#3
texasalynn Board Regular Join Date: May 2002 Location: Houston, TX Posts: 7,184	This is great and is exactly what I want to do, but I'm not getting how to put them together. Could you give an example.

May 20th, 2002, 12:39 PM	#4
tealeaf Board Regular Join Date: May 2002 Location: mtl, canada Posts: 160	my rather primitif way of doing it is just copy-paste one into the other...any better suggestions anyone?