I am seeking some theoretical knowledge regarding the limitations of VBA.
Some guidelines to note when replying:
- If you would like to reply to this post but you only know a few of the answers, please give us what you can (Answers to some of the questions is better than none to any)
- When answering, please add the question number so it's obvious to anyone reading your reply which question you are answering.
- If an answer is likely to vary depending on Excel version, please indicate this.
- If an answer is likely to vary depending on the computer specs, please indicate this.
- I would appreciate it very much if you could please provide a hyperlink (or reference) to the source for your answer if possible (rather than something along the lines of "well that's what I think anyway")
QUESTIONS
What is the maximum possible...
- ...number of modules you can have in a VBA project?
- ...number of macros you can have in a VBA project?
- ...number of code lines in a single procedure?
- ...number of characters in a single code line?
- ...size of a module?
- ...size of a VBA array?
- ...number of characters in a string variable?
- ...number of characters in a constant?
- ...number of references in a VBA array?
Bookmarks