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