Recorded Macro to a Usable Macr

Location: http://www.mvps.org/dmcritchie/excel/recorded.htm Home page: http://www.mvps.org/dmcritchie/excel/excel.htm [View without Frames]

Recording a macro shows some instructions that can be used, but seldom generates good code. This article will attempt to help you make use of your recorded code.

When I saw this post I figured I'd been waiting too long to start this page.

The following was a reply post by Brian Wilson 2000-06-21 in misc

Excel page Tip archives Referring to Ranges in Your VBA Code
http://www.j-walk.com/ss/excel/tips/tip20.htm
http://www.j-walk.com/ss/excel/tips/tip10.htm
http://www.j-walk.com/ss/excel/tips/tip07.htm
http://www.cpearson.com/excel/named.htm
http://www.cpearson.com/excel/cells.htm

Recording a macro and examining the code can be informative, but many times the recorded code is not the most efficient method--for example, the recorded code usually selects cells/ranges, and in many cases the same result can be achieved in a faster time without doing the selections.

(placeholder)

You are one of many distinguished visitors who have visited my site here or in a previous location since this page was created on June 21, 2000.

Visit [my Excel home page] [Index page] [Excel Onsite Search] [top of this page]

Please send your comments concerning this web page to: David McRitchie send email comments

Recorded Macro to a Usable Macr

Related