Code efficiency

[abousetta]

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