There isn't really a way around it. There is a limit to the size of a
procedure. At the end of the first half you can call the 2nd half (new
procedure) or you can call both from a new procedure.
--
JNW


"DB74" wrote:

how do you split a large procedure into two or more smaller procedures? I
put an End Sub statement, but then I need to run two seperate macros...is
there a better way so I only have to run 1?