Calculations Macro in Excel

You can access worksheet cells in Excel using the row and column index numbers and then perform calculations.
Cells(1,1) means you are now accessing cell with row number 1 and column number 1 or the cell A1.
Once you know the process of referring to the cells, you can then perform arithmetic calculations or formatting. View the online training video to understand the details like:

  1. How to start the Visual Basic Editor
  2. How to name a macro
  3. How to write the code to refer to the appropriate cells and perform calculations
  4. How to save a macro enabled Excel file

Watch the Excel VBA training video on YouTube

Calculations Macro