Macro to insert blank rows so that the total number of rows with data is equal to 1021

[nsm1411]

Hi there,

I have a total number of 263 sheets in my Excel file. Each sheet has a different number of rows with data. Could anyone please help me create a macro that can insert the blank rows from the top so that the total number of rows (including the blank rows) is equal to 1021.

Many thanks in advance.

Best,

N

[Alf]

Perhaps a macro like this?

Please Login or Register  to view this content.

As this macro is based on a guess as you have not specified how your data is organized in the different sheets I recomend that you backup your data before testing the macro

Alf

[nsm1411]

Dear Alf,

Thank you very much for your help! The macro works perfectly!

Best,

N

[Alf]

Glad to be of help and thanks for feed back. You should be aware of the limitations of this macro i.e. assuming your data goes from row 1 to row 25 but row 3 is empty then the command

Please Login or Register  to view this content.

will be 24 not 25 as row 3 is empty and therefore "not used".

As this seems to take care of your problem could you please sign your thread "Solved" and if you like to give a rating to my answer click on the small star in my post (bottom left).

Alf

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

[nsm1411]

Just did that. Thanks again

N