Excel Macro to Run Other Macros
The Litigation Support Tip of the Night for March 7, 2016 shows how to run the four macros mentioned back in February on my site http://www.litigationsupporttipofthen... simultaneously to 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()
macro1
macro2
macro3
End Sub
Sub option2()
Call macro1
Call macro2
Call macro3
End Sub
. . . becomes in this Night's example:
Sub option1()
AutoFitAll
UnFreeze
Unfilter
PasteValue
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-qu...
Litigation Support Tip of the Night - a new tip each night.