1 macro built of smaller macros

[firefiend]

hi folks, kind of a silly question here but what is the syntax for inserting small specialized macros into a larger macro.

I built smaller macros to perform specific tasks that will most likely change with semi-regularly so to make edits easier I kept the tasks seperate.

But now I need to string them into a single master macro.

If all the macros are contained in the workbook where they will be used do I still use the Application.Run command?


It seems that the sub macro() heading makes it comparable to PhP functions but I'm not sure what the VBA syntax is to call the sub.

Anyone dig the vibe?

[jasoncw]

Application.Run "macro" will work. You can also use Call macro.

[firefiend]

Application.Run "macro" will work. You can also use Call macro.

so the syntax would be

Please Login or Register  to view this content.

?

[jasoncw]

No, it would be simply:

Please Login or Register  to view this content.

[firefiend]

I did not know that one.

Thanks,

[jasoncw]

No problem.