Programmatically move worksheets within workbooks
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 VSTO Add-in projects for Excel. 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.
To move a worksheet in a VSTO 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.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for