Code efficiency

Hello all members,

Many people who use macros first tend to use the internal Excel VBA recorder to record what they need excel to do (e.g. format cells, add formulas, etc). Recently I have realized the inefficiency associated with the resulting code requiring some cleaning up and removal of unneeded pieces of code. Since I am still new to world of vba, I would please ask everyone who has experience with this issue to list tricks they know to increase the efficiency of the recorded code. For example, in a recent thread, I asked for advice on how to deal with. Select http://www.excelforum.com/excel-prog...-in-macro.html and was given some very useful advice. I hope that members of this forum will be able to share their experience so that newcomers will find one source for making their macros more efficient.

Thanks.

abousetta

Hello abousetta,

Wow, that is like asking, "Explain the universe and give three examples." That is a very broad question and not one that can be answered in a few sentences. Books have been written on this subject. If you had some specific code examples in mind, that would provide a better starting point for the discussion.

You could read through the thread at http://www.excelforum.com/excel-prog...id-in-vba.html

Take some of what you read there with a grain of sand. My recommendations are, of course, grains of gold.

As Leith says, you've asked a very broad question. In return, here's a very broad answer: http://www.excelforum.com/excel-prog...id-in-vba.html
Note, it's a good idea to read the whole thread because some points (eg mine!) are over-ruled/corrected by more knowledgeable members in subsequent posts.

Edit: I posted before seeing Shg's reply. But after seeing Shg's reply, I'll add...
LOL, in other words, I've shared some of the grains of sand! /end edit

btw, to create a link in your post, use the World icon that has a chain link on it (rather than the HTML icon).

hth
Rob

I suggest reading anything that you can get your hands on - the more you read the more you will learn, even with the caveat that you may have to brush off the occasional grain of sand. Here are some links:

http://msdn.microsoft.com/en-us/library/aa730921.aspx
Also, read through the author's site http://www.decisionmodels.com/

http://www.thecodecage.com/forumz/ex...de-2007-a.html

http://blogs.msdn.com/excel/archive/...-in-excel.aspx

http://blogs.msdn.com/excel/archive/...practices.aspx

For a specific example discussed at length by DonkeyOte & others: http://www.experts-exchange.com/Soft..._25891900.html

hth
Rob