Delete every nth rows which is dependent on total number of rows

**maacmaac** · 02-23-2013, 08:52 PM

From a single sheet, I am trying to delete a certain block of rows, which is dependent on the total number of rows and leave a sample of ~ 100 rows of data. For example, if I have a sheet with 1000 rows of data, I want delete every row except rows 10, 20, 30, 40, 50, 60, 70, 80...etc (leaves ~100 rows). If I have a sheet with 300 rows of data, I want to delete every row except rows 3, 6, 9, 12, 15...etc.

I've been searching various forums but I can't find anything similar that would accomplish this task. Any comments appreciated. Thanks.

**arlu1201** · 02-23-2013, 11:52 PM

Is it always a constant of 100 rows that you require?

**maacmaac** · 02-24-2013, 12:45 AM

Yes, as close to 100 as possible plus or minus 5 or so. Thanks

**arlu1201** · 02-24-2013, 02:14 AM

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button