ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   about the limitation of bas module (https://www.excelbanter.com/excel-programming/387083-about-limitation-bas-module.html)

[email protected]

about the limitation of bas module
 
Hello,

I heard there is 4000 line and 64KB limits for each bas module in
Excel.
What happens if I exceed this limit??
We are developing some huge Excel2000 application having modules with
13000 line and 500KB at the largest
and there is no problem for now...

Thanks in advance.
Nio


Bob Phillips

about the limitation of bas module
 
Break the code down into multiple modules.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
ups.com...
Hello,

I heard there is 4000 line and 64KB limits for each bas module in
Excel.
What happens if I exceed this limit??
We are developing some huge Excel2000 application having modules with
13000 line and 500KB at the largest
and there is no problem for now...

Thanks in advance.
Nio





All times are GMT +1. The time now is 09:24 PM.

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