Maybe it's not a shortest way but it works

oWorkbook.Sheets.Add(,oWorkbook.Sheets(oWorkbook.Sheets.Count))

>
>It has been a long time since I have tried to automate excel. I need to add a new worksheet to the end of the list. I can't seem to make the parameters work with the add() method.
>
>o.ActiveWorkbook.Sheets.Add()
>
>I seem to remember that you can't pass named parameters with vfp so how do I make this work?