'Replace YourWorkbook.xls with the full name of the target workbook you want.ĪctiveSheet.Move Before:=Workbooks('YourWorkbook.xls').Sheets(1) 'Move the active sheet to the beginning of named Workbook. Move the active sheet to another Workbook Sub MoveToSpecificWorkbook()
In this example, we are moving Sheet1 before Sheet3. You can move sheets simply by calling them out by sheet name. Sheets('Sheet1').Move Before:=Sheets('Sheet3') Move Sheet 1 before Sheet 3 Sub MoveBefore() In this example, you can use Worksheet(Worksheets.Count) to point to the last sheet. But you can find the maximum count of worksheets, and then use that number as an index for the Worksheets object. There is nothing in VBA lets you point to “the last sheet”. Move the active sheet to the end Sub MoveEnd()ĪctiveSheet.Move After:=Worksheets(Worksheets.Count) In this example, we use Worksheets(1) to point to the first sheet in the workbook, and then move the active sheet before that one. You can use Move method to move the Worksheets and use Before argument or After argument to specify where to move the sheet to. Move Worksheets VBA Move the active sheet to the beginning Sub MoveBeginning() 2.2 Copy the active sheet to another Workbook.2.1 Copy the active sheet to a new Workbook.1.5 Move the active sheet to a new Workbook.1.4 Move the active sheet to another Workbook.1.1 Move the active sheet to the beginning.