Recorded Macro to a Usable Macr

Home page:
[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

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.


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