i have an application that creates many sheets within a workbook. i use:
myXLSheet = myxlBook.Sheets.Add(After:=myxlBook.Worksheets(myxlBook.Worksheets.Count))
to add each sheet.
i have a summary sheet that comes at the end and i need to get it into the very beginning.... i have tried using Before: instead of After: but haven't had any luck. can someone please let me know the parameters for .Add(Before:=) to get my summary sheet as the first sheet within the workbook?