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 |
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