Repeat part of the macro

Hi guys,

is it possible to repeat part of (but not all of) the macro from within the macro itself?

I am moving blocks of 25 lines from one document to another. What I would like, is at some point in the macro have a point (HERE) where the repetition would begin. I would then have the command to find and collect the 25 lines and directly below would like to put: if there is data below these 25 lines, go back to HERE. I've got the if part and the moving part, but don't know if there is a command to repeat or go back to a certain part of the macro.

Does anybody know if this is possible?

Perhaps a Do-Loop - search the forums or google for examples, come back with specifics if necessary.

VBA has lots of flow control structures. The only one I'd recommend you not use is the GoTo statement -- it makes code hard to maintain.

You code put the code to be repeated in a separate sub and pass the necessary variables, or have the code segment in the same macro and use GoSub.