How to use a macro in MS Excel

1. Go to your excel file
2. Press Alt+F11 to enter the VB editor
3. Go to Insert > Module
4. Copy and Paste in the code that you have downloaded.
5. Press Alt+Q to come out of VBA
6. Save the excel file and that's it

Now whenever you need to use the macro just press Alt-F8 and select it from the macro list.

Post a comment