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.
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