I want to delete specific rows from Microsoft excel. My data set has around 900,000 rows, I want to get ride of rows/columns that are for example, from b325890-b500000 without dragging my mouse down and clearing it. How would I do this? I am using Excel 2011 on A Mac.
Excel VBA Examples for Deleting multiple Rows at time
The following example will delete Row 5 to 10 at a time from the active worksheet.
'In this Example I am deleting Rows 5 to 10 Sub sbDeleteARowMulti() Rows("5:10").Delete End SubInstructions
- Open an Excel Workbook
- Press Alt+F11 to open VBA Editor
- Insert a Module from Insert Menu
- Copy the above code and Paste in the code window
- Save the file as macro enabled workbook
- Press F5 to execute it
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments