Note: Formulas are hardcoded in this sample for ease and brevity. If the spreadsheet were completely dynamic, you would not hardcode the formulas either but, instead, "point" to the range as shown below.
e. Cursor position is now in the first blank cell beneath column G's calculated formulas. Add this column for KC's grand total using the "point" technique, which is best for macros. Enter =SUM( [equal sum left parenthesis], Up, End, Up, Shift+End-Down, Enter. Grand total calculated, and the macro is finished.
Sign up for CIO Asia eNewsletters.