ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   proper form (https://www.excelbanter.com/excel-programming/329578-proper-form.html)

Gixxer_J_97[_2_]

proper form
 
Hi all

is it better (or is there any advantage or disadvantage) to using

Application.run MacroName:="MyMacroName"

over

call MyMacroName

tia

J

Jim Thomlinson[_3_]

proper form
 
I kind of like using call. Then you know that you are calling a sub within
the project. Just a convention I use though and certainly nothing scientific
here. As for performance there should be no difference.

Jim Thomlinson


"Gixxer_J_97" wrote:

Hi all

is it better (or is there any advantage or disadvantage) to using

Application.run MacroName:="MyMacroName"

over

call MyMacroName

tia

J


Gixxer_J_97[_2_]

proper form
 
thanks Jim - i was just curious


"Jim Thomlinson" wrote:

I kind of like using call. Then you know that you are calling a sub within
the project. Just a convention I use though and certainly nothing scientific
here. As for performance there should be no difference.

Jim Thomlinson


"Gixxer_J_97" wrote:

Hi all

is it better (or is there any advantage or disadvantage) to using

Application.run MacroName:="MyMacroName"

over

call MyMacroName

tia

J



All times are GMT +1. The time now is 04:19 PM.

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