| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Publishing a static table as html using jscript (Excel 2007) | Excel Discussion (Misc queries) | |||
| Why can't you just Move a worksheet in Excel '07 to new workbook? | Excel Worksheet Functions | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| move one row to another in excel (worksheet) | Excel Worksheet Functions | |||
| Excel - Rendering ASCII via ASP/JScript | Charts and Charting in Excel | |||
Linear Mode
