Excel Options -> Popular -> Show Devel
1. First open an existing Excel workbook which ha
2. Press Alt+F11 simultaneously which will open t
3. Then insert a module using Insert menu.
4. To try these examples, copy and paste the cod
5. Finally, save the file as macro.
To execute the code press the F5 function key. No
ular -> Show Developer Tab in the Ribbon
cel workbook which has data.
ously which will open the VBA editor.
ing Insert menu.
opy and paste the code given in this tutorial into the code window. Alternatively, you can manually type in the code.
the F5 function key. Now lets move on to the practical aspect of deleting rows in Excel.
ype in the code.