AFAIK it's not a matter of too many variables, it's a matter of how
much text is in the macro/module. that's why JLGWhiz can have such a
large macro & it runs fine - he's got it broken up into many different
modules. if he tried to put it all in one macro and/or one module, it
would be too long.
if you break up your macro, as suggested, into different modules, you
should not encounter that error any longer.
best wishes!
:)
susan



On Nov 3, 12:52*pm, Don M. wrote:
Does the Procedure Too Large error result from too much text in the macro or
this a memory space thing? I thought this was all from having too long a
macro all this time. Do I just have too many variables?

Don