| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
How to move worksheet from vbscript
Hi,
I want to move the last worksheet to be the first, but I don't the syntax becuase the method usually requires a named argument (Befo=location): ' create an Excel object set xlApp = CreateObject("Excel.Application") set xlWb = xlApp.ActiveWorkbook ' move the last worksheet to be the first... xlWb.Sheets(xlWb.Sheets.Count).Move Befo=xlWb.Sheets(1) This causes an error. I know that I can't use the Excel named argument syntax, but then how DO I specify the location to move the sheet? Many thanks in advance, Robert Stober |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run VBScript from Excel | Excel Discussion (Misc queries) | |||
| conditional formatting + VBscript | Excel Discussion (Misc queries) | |||
| Worksheets.add in VBScript overwrites existing worksheet | Excel Worksheet Functions | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| Entering a formula via VBscript | Excel Programming | |||
Threaded Mode
