Why not use the Excel Macro Recorder for everything?
Unfortunately there are a lot of things you cannot do with the Excel Macro Recorder. For example, we cannot loop through a range of data with the Macro Recorder. Moreover the Macro Recorder uses a lot more code than is required, which can slow your process down. To record, run and edit a recorded macro, execute the following steps.
