Need macro to insert a blank row after every 11 rows

[abjac]

Hi I need a macro which can insert a blank row after every 11 row. It shall start from row 2 so it can keep the header.
And insert all the way down in the sheet , and also for the last one, even if there is not 11 in the last one.

In this below example there is a button in Sheet1 and it have to activate the code in Sheet2

Please have a look and see if some can help with this.

Thanks in advance

Sincerely Abjac

[abjac]

Sorry i have found the solution. Bu for other here is the code.

Please Login or Register  to view this content.

[AB33]

I do not know if this what you wanted. It may be to simple

Please Login or Register  to view this content.

[abjac]

Hi AB33. Thanks for you help. I checked this code and the result is not correct. It stop on row 1433 and after there it dont insert a blank row.
The first code i found working perfect. So no need to use all your time on this one, only if you want to find out of, why its not working then.
Thanks allot.Great forum and so nice many wants to help.

Have a nice day

Sincerely

Abjac

[AB33]

Abjac,
Glad to know that your code working fine for you, but my code is not same code as the one you have.

Both codes are different and produce different result.

You said
"It shall start from row 2 so it can keep the header".
My code insert rows starting from row 2, but your code starts at row 11.

[abjac]

HI AB33. Your right i think i make a wrong way to say it. I know what you mean. Your code is working perfect also. Its true. I guess your code, should start from row 12. 11 minus the header, Then it will do what i had in my mind, but not communicated correct to you.
Your code is working perfect.

Thanks allot for explaining.

Have a nice day

Sincerely
Abjac