what is the difference Excel VBA: Call and Run

[jamilm]

Dear Gurus,

grateful if you could elaborate on the difference between VBA Run and Call


thanks.

best regards,

 

[Andrew Poulsom]

One difference is that with Call the called procedure must be explicitly named, whereas with Run it can be built up by concatenation.

 

[jamilm]

One difference is that with Call the called procedure must be explicitly named, whereas with Run it can be built up by concatenation.

Thank you Andy.

best regards,

 

[JosephP]

run breaks the call stack. it also allows you to call routines in other (unreferenced) workbooks and private routines. it passes all arguments by value instead of by reference. and as was already said it allows you to pass a string as the routine name. call is generally used within a project unless you need the behavior of run for some reason

 

[jamilm]

run breaks the call stack. it also allows you to call routines in other (unreferenced) workbooks and private routines. it passes all arguments by value instead of by reference. and as was already said it allows you to pass a string as the routine name. call is generally used within a project unless you need the behavior of run for some reason

many thanks Joseph