ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   JScript to move Excel Worksheet (https://www.excelbanter.com/excel-programming/271218-jscript-move-excel-worksheet.html)

Kenneth Chin

JScript to move Excel Worksheet
 
Using JScript, how do I move a worksheet so that it is at
the end of the workbook?

Currently using JScript, I can create an Excel Workbook
and add sheets to it, but all the new sheets are added in
the front of the workbook.

--Ken

Chong Moua

JScript to move Excel Worksheet
 
Hi Ken,

Try this ...
--------------------------------------
'to add sheets to back
Sheets.Add after:=Sheets(Sheets.Count)

'to move Sheet1 to back
Sheets(1).Move after:=Sheets(Sheets.Count)
--------------------------------------
Hope this helps...

Chong Moua

-----Original Message-----
Using JScript, how do I move a worksheet so that it is at
the end of the workbook?

Currently using JScript, I can create an Excel Workbook
and add sheets to it, but all the new sheets are added in
the front of the workbook.

--Ken
.



All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com