That's how you can duplicate a sheet in Excel with VBA.MsgBox 'SL No Can Not be Blank!!!', vbExclamation, 'SL No' In your worksheet, press Alt + F8, select the macro of interest, and click Run.Open your own workbook and navigate to the sheet you want to copy.Open the downloaded workbook and enable the content if prompted.To run the macro in your Excel, just do the following: The sample workbook contains the following macros:ĬopySheetToNewWorkbook - copies the current worksheet to a new workbook.ĬopySelectedSheets - copies multiple sheets that you select to a new workbook.ĬopySheetToBeginningAnotherWorkbook - copies the active sheet to the beginning of another workbook.ĬopySheetToEndAnotherWorkbook - copies the active sheet to the end of another Excel file.ĬopySheetAndRename - duplicates the current sheet, renames it as specified by the user, and puts the copy after all other sheets in the current workbook.ĬopySheetAndRenamePredefined - duplicates the active sheet, gives a hardcoded name to the copy and places it at the end of the current workbook.ĬopySheetAndRenameB圜ell - makes a copy of the active sheet and renames it based on the selected cell value.ĬopySheetAndRenameB圜ell2 - copies the active sheet and renames it based on the hardcoded cell address.ĬopySheetToClosedWorkbook - allows you to copy sheet to a closed workbook.ĬopySheetFromClosedWorkbook - enables you to copy a sheet from another Excel file without opening it.ĭuplicateSheetMultipleTimes - lets you duplicate a sheet in Excel multiple times. How to run a macro from our sample workbookĪlternatively, you can download our sample workbook to Duplicate Excel Sheets and run the code from there. On the left pane, right-click ThisWorkbook, and then click Insert > Module.įor the detailed step-by-step instructions, please see How to insert VBA code in Excel.Press Alt + F11 to open the Visual Basic Editor.To insert the code in your workbook, perform these steps:

To copy a sheet in Excel with one of the above macros, you can either insert the VBA code into your own book or run a macro from our sample workbook. How to duplicate sheets in Excel with VBA Open the original sheet, run the macro, specify how many copies of the active sheet you want to make, and click OK:

N = InputBox( 'How many copies of the active sheet do you want to make?')ĪctiveSheet.Copy After:=ActiveWorkbook.Sheets(Worksheets.Count)

Excel vba userform templates downloads