Maximum Number of Macros?

[dlanden]

Probably a simple question, but is there a limited number of Macros that can be run in a single workbook? Thanks for your help.

 

[Norie]

Not that I know of.

There are limitations on the length of code but that can normally be overcome by streamlining/tidying the code.

 

[Smitty]

I haven't run into that one before (or even needed to ask the question), but I'd imagine that's entirely dependent on what your system can handle efficiently.

E.G. the only limitation to the number of wb's you can have is your system's available memory.

Now you will bug out if a particular sub is too long, but that's usually only encountered with really inefficient code (lots of selects and navigation from recorded code'll do it).

Smitty

 

[dlanden]

Thanks a lot for your help. The reason I asked is that I have macros that run macros if that makes any sense. Thanks again.

 

[Norie]

Of course it makes sense, that's standard practice.

But we can't really give more advice without more information.

 

[Bob Rooney]

I just ran a personal use add-in through Rob Bovey's Code Documenter. I have 876 Subs or UDFs and nearly 23K lines of code.

The add-in is around 4 MB. Workbooks with a lot of data can get far larger, so I don't think I am anywhere near any limits (Excel 2003).

Are you noticing any problem with your code? Is it something general which prompted your question, or can you pinpoint a specific procedure which may be causing the problem?

 

[Smitty]

I'd like to see that Add-In Bob!

Smitty

 

[dlanden]

To Bob Rooney:
I am not experiencing any problems or a slow system I just wanted to make sure I wasn't going to crash my workbook! I actually only have twelve macors in the workbook but one time I wrote a macro that was so long that it actually wouldn't run :x . That is when I came up with the idea of having a macro run a macro.
Dave