Run 46 macros in one module

[meirm]

I built a file which copies the same range from 46 different spreadsheets in one file to a second file with identicle spreadsheets. The macros are all sitting ib the same module. I'm looking for a macro to run them by refering to the module they're located in rather then having to code 46 calls.

 

[jolivanes]

Re: "wouldn't it just be easier to call each of the 46 macros that I already have"
No, for maintenance sakes it is easier to have a list of sheet names. It will be faster also.
What is the naming convention of the sheets to be copied?

I'll have a look later on when I have some more time.

 

[jolivanes]

You have to follow the reasoning in Post #8. I can't see that from here.
But you've found a good reason why not to go the way you want to go. Too many possibilities for things to go wrong like spelling not the same, extra spaces etc etc.
You have to go through everything to make sure there are no differences. That could be many things.

 

[meirm]

In the end, I found a macro that lists all my macro names in a spreadsheet. Using the excel textjoin, I combine the macro name with the term call and was able to copy the entire list at on time to a macro that ran them all. It's primitive but works. I would prefer to use a more sophisticated VBA program to achieve the same thing.

 

[jolivanes]

Re: "I would prefer to use a more sophisticated"
Post #11 has suggestions.
If the sheets that need copying have a part of the name in common, you can use that easy enough or a small macro to output the sheet names into a sheet but you need to let us know.
i.e. if all the sheet that need to be copied start with "Invoice" you just cycle through these sheets and copy/paste.
Or, as mentioned, use a list in a hidden sheet.