Open the Excel 2010 worksheet that contains the rows you want to delete. Press "Alt+F11" to launch the VBA code editor.

‘Cycle through rows in selRange and delete entire row when crit ‘equals the current value. j = 0 For i = selRange.Rows.Count To 1 Step -1 If crit = selRange.Cells (i, 1).Value Then ...

1] Delete multiple rows in Microsoft Excel through the contextual menu This trick works well when you intend to delete multiple consecutive rows, follow these steps: 1] Open Microsoft Excel sheet ...

Visual Basic Application or VBA , when used in Microsoft Excel, is an efficient tool, as repetitive jobs can be automated with its help. Users can even write custom VBA code to meet their programming ...