To Create Dynamic or Run-time WorkSheets using Macro, follow the steps mentioned below
Steps:
- Get the Active WorkBook object
- Add the worksheets at the run time using Add().Name() method
Get the Active WorkBook object
Set mainWorkBook = ActiveWorkbook
Add the worksheets at the run time using Add().Name() method