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.

Related

(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


Copyright © 1997 - 2004,  F. David McRitchie,  All Rights Reserved