With the main parts of the macro to create form analysis complete, it's time to start perfecting the code to get exactly the output we require.  In this video, we look at several advanced coding ideas including dynamic position control using .cells, variables and loops.

The main learning outcome from this session, however, is learning how to test, debug and improve a powerful Excel VBA routine.  With a complicated macro such as this, things never go entirely as planned, so it's essntial (1) to respond in the right way emotionally (without throwing your laptop of the window) (2) to have a debug routine to enter into.  Code not working?  No problem - we know it's all part of the game.  So, let's get into our debug routine, and let's get this code working smoothly ...

Tools And Techniques

- dynamic position control
- combining .cells(x,y) with a variable
- benefits of named ranges
- static vs. dynamic code
- advanced debugging with the VBA editor
- filtering