Confirmation required

[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.

 

[David Heaton]

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.

Bobby,

Excel will load the sub when it called

Regards

David

 

[Bobby]

Bobby,

Excel will load the sub when it called

Regards

David

In other words only SUB number 1! Correct?

 

[David Heaton]

In other words only SUB number 1! Correct?- Hide quoted text -

- Show quoted text -

if that is the sub you are calling then yes

 

[Bobby]

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

- Show quoted text -

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.