ExcelVBA

Introduce

Something useful for excel automation that improves your effectiveness.

Software Architecture

For user convenience, and to avoid reference issues, all subprocedures(sub) and functions are in one file.

Install Tutorial

1. Show the Developer tab in Excel: https://support.microsoft.com/en-us/office/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45
2. Open "Visual Basic" under "Developer tab"
3. Insert model (Alt + I + M)
4. Paste code and press F5 to run