Here, range is storing our current selection of cells and then ‘a’ contains rows count and ‘b’ contains columns count and then message box shows the total area. Step 2: Go back to the Calc workbook and select some cells and run your macro. 78