Conditional Deleting of rows based on how many and how much?

[Rabbitstew]

Hi Guys,

Can someone write me a script that can delete specified # of rows after # of rows specified?

for example: Delete 2 rows after every 38 rows.

Thanks in advance!

[111StepsAhead]

Do the rows that you are deleting have something in them that distinguishes them from other rows? If yes, there is a better way to do what you are asking.

Please Login or Register  to view this content.

The above should do what you ask but there are better ways to delete variable rows.

[Paul]

Hi Rabbit,

I think you would need to call 111's code from another macro, passing it the a and b values. If you were just looking to run a macro to delete every 39th/40th rows (assuming starting in row 1), you could use:

Please Login or Register  to view this content.

This will delete rows 199 & 200, 159 & 160, 119 & 120, 79 & 80, 39 & 40.

[xladept]

Hi Rabbitstew,

You could try something like this:

Please Login or Register  to view this content.

XLAdept

[Rabbitstew]

Awesome! thanks everyone!