Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can programmatically change the position of worksheets relative to other worksheets in a workbook. If you do not specify a location for the moved sheet, Excel creates a new workbook to contain it.
Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
To move a worksheet in a document-level customization
Assign the total number of sheets in the workbook to a variable and then move the first worksheet so that it becomes the last one.
Dim totalSheets As Integer = Application.ActiveWorkbook.Sheets.Count Globals.Sheet1.Move(After:=Globals.ThisWorkbook.Sheets(totalSheets))int totalSheets = this.Application.ActiveWorkbook.Sheets.Count; Globals.Sheet1.Move(missing, Globals.ThisWorkbook.Sheets[totalSheets]);
To move a worksheet in an application-level add-in
Assign the total number of sheets in the workbook to a variable and then move the first worksheet so that it becomes the last one.
Dim totalSheets As Integer = Application.ActiveWorkbook.Sheets.Count CType(Application.ActiveSheet, Excel.Worksheet).Move(After:=Application.Worksheets(totalSheets))int totalSheets = this.Application.ActiveWorkbook.Sheets.Count; ((Excel.Worksheet)Application.ActiveSheet).Move(missing, this.Application.Worksheets[totalSheets]);
See Also
Tasks
How to: Delete Worksheets from Workbooks