A Macro to Run Other Macros

A Macro to Run Other Macros

March 7, 2016

This night's tip shows how to run the four macros mentioned back in February to simultaneously help format data on all worksheets of an Excel spreadsheet.    



The macro to paste the values of all formulas on February 29, 2016. 


The macro to unfilter data on February 25, 2016.


The macro to autofit colums and rows on February 20, 2016


The macro to unfreeze on February 17, 2016.  



You just need to insert this macro in a new module and edit it to refer to the macros you want to run.  So:











Sub option1()
End Sub

Sub option2()
Call macro1
Call macro2
Call macro3
End Sub



. . . becomes in this Night's example:



Sub option1()
End Sub

Sub option2()
Call AutoFitAll
Call UnFreeze
Call Unfilter
Call PasteValue
End Sub


Follow the instructions provided on my YouTube channel.












Thanks to AJ for this tip at http://www.mrexcel.com/forum/excel-questions/11487-execute-multiple-macros.html 

Please reload

Contact Me With Your Litigation Support Questions:


  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com