Confirmation required

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Hello community,
Could someone tell me if when you have a MODULE containing let say 5
differents SUB's(SUB number1, SUB number2 etc), if you run SUB
number1, will EXCEL load in memory all the 5 SUB's or only SUB
number1?
Thank's in advance.
 
Hello community,
Could someone  tell me if when you have a MODULE containing let say 5
differents SUB's(SUB number1, SUB number2 etc), if you run SUB
number1, will EXCEL load in memory all the 5 SUB's or only SUB
number1?
Thank's in advance.
Click to expand...

Bobby,

Excel will load the sub when it called

Regards

David
 
if that is the sub you are calling then yes- Hide quoted text -

- Show quoted text -
Click to expand...

Thank's David. David are you aware if it possible to load in memory a
SUB that is often called? So like that EXCEL would not have to read
the SUB from disk but directly in memory(better performance).
Regards.
 
Back
Top