ABSTRACT
When constructing a macro for any purpose, it would be most intuitive to place the macro code within the workbook where the data will be manipulated. In fact, that is exactly what is done when a macro is recorded using the macro recorder. While this is the easiest thing to do, it is not the best thing to do.
