EXCEL 2007 MACROS FOR FINANCIAL CALCULATIONS

The performing of the financial calculations (but also of other types of calculations) often becomes a routine, repeatable activity. In Excel the automation of the work is possible by using macros which are registered and which can be edited. By the Recording procedure the addresses related to a domain of cells is memorized, that can be an impediment for the developing of the calculation in another zone of the electronic calculation sheet. The visual Basic for Application language associated with the Excel editing environment offers the possibility to remedy this drawback