Microsoft Excel VBA macro developing basic guide
Microsoft Excel is a powerful application when it comes to processing and analyzing data. With the help of hundreds of inbuilt formulas and functions you can do very powerful tasks easily by Excel. If you have some VBA knowledge (Visual Basic for Applications), you can avoid doing repetitive tasks and save your precious time. Lets say you have to process a report generated on daisy basis and the tasks you have to do with that report are same, why not you automate it. Those simple yet very powerful programs are called macros. In this blog I will start from the very beginning and will take you to the very advanced levels of macros. I think the best point to start is macro recorder. You can achieve automated tasks for certain extent using the macro recorder. Let's see how it is done. Open Excel 2007 and open a new workbook. Enter the numerical values to the cells as in the figure. Lets say you want get the sum of A1 and B1 cells to C1 cell and do this till A11 an