Open the Excel 2010 worksheet that contains the rows you want to delete. Press "Alt+F11" to launch the VBA code editor. Right-click on the name of your current worksheet, which is listed on the ...

If you are unfamiliar with working with VBA, here is the short version of how to make use of this: Open your worksheet in Excel. ALT-F11 (opens the VBA coding window) ...

If you want to accomplish the same thing from inside Excel—for instance, display and populate an appointment while working in Excel—you’ll need a bit of VBA magic.