ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Maximum amount of macros supported (https://www.excelbanter.com/excel-discussion-misc-queries/105907-maximum-amount-macros-supported.html)

Bror

Maximum amount of macros supported
 
I was just wondering what the maximum amount of macros is that you can
implement into excel because it fails when I want to add the 17th macro. So
could it be that the maximum is set on 16? I would be surprissed.

Dave Peterson

Maximum amount of macros supported
 
I'd guess that it's something else.

But there is about a 64k character limit in any one module. But you can have
lots of modules.

Bror wrote:

I was just wondering what the maximum amount of macros is that you can
implement into excel because it fails when I want to add the 17th macro. So
could it be that the maximum is set on 16? I would be surprissed.


--

Dave Peterson

JLatham

Maximum amount of macros supported
 
As Dave Peterson said, each individual module has a 64K limit, so your macros
would have to be huge.

Exactly what error are you getting?

"Bror" wrote:

I was just wondering what the maximum amount of macros is that you can
implement into excel because it fails when I want to add the 17th macro. So
could it be that the maximum is set on 16? I would be surprissed.



All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com