Repeating a specific macro over subsequent lines

[stepheng2383]

Hi All,

I have created a macro which will run over a specific range of data (i.e. lines 5-13). It involves changing the format and layout of tab-delimited cell content.

The output files I'm working with involved a series of repeated outputs which are different from each other and I would like to repeat this same macro for each subsequent section to the bottom of the Excel form (i.e. macro is currently running over lines 5-13, but would also like to repeat it for lines 15-23, 25-33, 35-43, 45-53, etc).

The current macro in use over lines 5-13 is currently 13 pages long in a Word document, size 12 font, so if possible, I would like to just repeat it for each subsequent section, rather than rewrite it. In some cases there will be up to 35 sections below the first, each 9 lines long.

I would appreciate any help that can be provided. Thanks.

[Leith Ross]

Hello stepheng2383,

Welcome to the Forum!

Is your question about an Excel or a Word?

The current macro in use over lines 5-13 is currently 13 pages long in a Word document, size 12 font, so if possible, I would like to just repeat it for each subsequent section, rather than rewrite it. In some cases there will be up to 35 sections below the first, each 9 lines long.

You should also post the macro code.

[davegugg]

You may have to take the code you have and change all references to the range to variables, then you can just repeat the sub you have for different ranges.

As an example if you have:

Please Login or Register  to view this content.

instead put

Please Login or Register  to view this content.

Then you can add whichever rate ranges you want to do it over.
Dave

[stepheng2383]

In response, this post is referring to Excel. Also, davegugg, one is I encountered with replacing specific numbers (in reference to row numbers), was the it would replace all numbers, include those referencing colors. In essence, this would change all the colors being formatted through the macro as well.

The code is as follows:

Please Login or Register  to view this content.

[Note: This is just an example of the start of the code, as it ran 11,000 characters over the length of the available posting space; the remaining has been cut]

I'm sure this could be cleaned up quite a bit as well and now, after copying these down more than three times, I run into a "Compile Error: Procedure too large" error. If anyone has any spots that can be cleaned up, this would be helpful as well. Remember, I'm trying to copy this macro, which affects row 5 through row 13, over additional selections; row 15 through row 23, row 25 through row 33, etc.

Thanks guys!