If your macro did not perform as expected, the easiest, and best option is to follow the steps of the tutorial again and re - record the macro.
Editing/Step Into a Macro
An Excel macro is written in the Visual Basic for Applications (VBA) programming language.
Clicking on either the Edit or Step Into buttons in the Macro dialog box starts the VBA editor (see the image above).
Using the VBA editor and covering the VBA programming language is beyond the scope of this tutorial.