Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

5 tips for creating macros perfectly in Office applications

JD Sartain | March 23, 2015
Shrink hours of labor to minutes with these easy time-saving techniques.

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. 

 

Previous Page  1  2  3 

Sign up for CIO Asia eNewsletters.