how to write efficient macro

ap1 · Mar 26th, 2002, 12:22 PM

i am recording a macro and looks like lot of code is duplicate like page setup etc which i did multiple time while recording. do u know what statements i can delete from macro and still achieve same results and remove redundant code.
Thanks

Tom Schreiner · Mar 26th, 2002, 12:27 PM

Hi
Post your macro.
Better yet,
Experiment by commenting out code and learn what it does

Great place to start in learning VBA!

TOm

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

Mar 26th, 2002, 12:22 PM	#1
ap1 New Member Join Date: Mar 2002 Posts: 26	i am recording a macro and looks like lot of code is duplicate like page setup etc which i did multiple time while recording. do u know what statements i can delete from macro and still achieve same results and remove redundant code. Thanks

Mar 26th, 2002, 12:27 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Post your macro. Better yet, Experiment by commenting out code and learn what it does Great place to start in learning VBA! TOm