Macro size limit?

[Belinda Robinson]

Dear All
Is there a limit or a desirable maximum size of a macro? for instance one of
our users has recorded lots of actions into one macro (and intends to keep
adding to it). At present the macro is 117kb (13 pages of printed text).

He can split the macro into several separate ones if size is an issue.

Thanks in advance.
Belinda

 

[Chip Pearson]

Belinda,

You should split the module in to several modules, each less than 64KB.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Belinda Robinson]

Thank you for your response.
Sorry to be dumb, but I'm not much of an Excel user,
As a result:
If I split the module into two, is it possible to add a macro to the first
module saying 'now run the next module'?
Apologies if I say macro when I should say module or vice-versa!
Thanks
Belinda
***********

 

[Chip Pearson]

Belinda,

You can't split an individual macro across modules. A macro must be entirely
contained within a single module. But if you have a single macro that is
117KB, you should really redesign it in to several macros, for purposes of
organization, structure and re-usability.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com