Combining macros to be one and run in a specific order

**Misbah211** · 08-09-2012, 05:47 AM

Hey, I'm novice with VBA so I'm not familiar with combing macros to be one and run in a specific order. This is what I was trying.

Please Login or Register  to view this content.

I've also tried this method, but this isn't working either.

Please Login or Register  to view this content.

Thanks in advance!

**Jockney** · 08-09-2012, 06:09 AM

Best way to do this is recording you running the macro's. Then take note of what recorded for future reference. It all depends on what your Excel workbook is saved as so for easy sake hit the record button and then run them in the order you want them to run. Once this is done you'll have a shiney new macro which runs them in the order you want. If you need any more help then let me know

**arlu1201** · 08-09-2012, 06:31 AM

In the 1st code, there is only 1 sub. In the 2nd sub, you are calling 4 subs that do not have the same name as the 1st sub.

**Jockney** · 08-09-2012, 09:34 AM

Please Login or Register  to view this content.

Then record you running the four Macro's in the order you want.

**Misbah211** · 08-11-2012, 10:13 AM

Hey sorry for not getting back to you, not had any internet access. Emm I tried recording a new macro by clicking the existing ones in the order I wanted to run them, but nothing gets recorded.

I also tried that call method but that didn't work either.