Open the Excel software on your desktop and open the Excel spreadsheet that contains the function you want to edit. Click the "VBA" button in the "Developer" tab or ribbon. Your VBA code opens.

Once you set up your VBA code correctly, all you have to do is press a button and all the targeted rows will be deleted. Open the Excel 2010 worksheet that contains the rows you want to delete ...

The code name is the sheet’s default name , which Excel assigns when you create it — Sheet1, Sheet2, and so on. Changing the sheet’s name, as displayed on the sheet’s tab, does not change ...