Automation & Macro Creation Flashcards

You want a recorded macro to be available in every workbook you open on your computer. Where should you store it?

Answer: Personal Macro Workbook

Macros saved to the Personal Macro Workbook (PERSONAL.XLSB) load automatically whenever Excel starts.

While recording a macro, you want the steps to apply relative to whichever cell is active when the macro runs. What should you turn on before recording?

Answer: Use Relative References

Use Relative References makes the recorder save cell moves as offsets from the active cell instead of fixed addresses.

Which VBA statement finds the last used row in column A, even if there are blank cells in the middle?

Answer: Cells(Rows.Count, 1).End(xlUp).Row

Starting at the bottom of the sheet and moving up with End(xlUp) lands on the last non-empty cell.

What happens to Excel's Undo history after a VBA macro changes cell values?

Answer: The Undo stack is cleared and the changes cannot be undone with Ctrl+Z

Running a macro that changes the workbook clears the Undo stack, so its actions can't be reversed with Undo.

Which keyboard shortcut opens the Macro dialog box so you can run, edit, or delete macros?

Answer: Alt+F8

Alt+F8 opens the Macro dialog box, while Alt+F11 opens the Visual Basic Editor.

A macro must run automatically every time a user opens the workbook. Where should the code go?

Answer: A Workbook_Open event procedure in the ThisWorkbook module

Workbook_Open is a workbook-level event and must be in the ThisWorkbook module to fire when the file opens.

Which statement at the top of a module forces you to declare every variable with Dim before using it?

Answer: Option Explicit

Option Explicit causes a compile error whenever an undeclared variable is used, which catches typos.