Ok, open your VBA editor again, put the cursor in the code and click the "F8" key to step through the macro line by line. After the first loop, you can click the Run button "F5"
Does the macro run? Yes, there is nothing wrong with the macro. Perhaps you have not properly set your shortcut key.
|