Tabellab
Beginner

Macro Recorder & Cleanup

Record what Excel does, read the code it produces, and rewrite it into something fast and reliable.

8 lessons 57 min Certificate

The first lesson is free — no account needed.

About this course

The Excel VBA macro recorder is the quickest way to find the code for a task, and its output is the slowest way to run it. You record macros with absolute and relative references, read the generated code, remove Select and Activate, use With blocks and variables, and rewrite a recording step by step into a fast, reliable macro.

Lessons

  1. Recording a MacroReading11 minFree
  2. Absolute and Relative RecordingReading6 min Pro
  3. Reading the Generated CodeReading7 min Pro
  4. Why Select and Activate Are BadReading7 min Pro
  5. With Blocks and VariablesReading6 min Pro
  6. Rewriting a Recording, Step by StepReading8 min Pro
  7. Making It Fast and SafeReading6 min Pro
  8. Using the Recorder as a Lookup ToolReading6 min Pro