Solved: Adding Worksheets: left or right?

[jungix]

When I add a worksheet in a workbook thanks to a macro (Worksheet.Add), it is always created on the left of my existing worksheets. I would need it to be added on the right? Is this possible?

[lucas]

Here is an example of how to copy a worksheet to the end....change copy to add.... basically use before and after

Sub CopySheet()
Dim TotalSheets As Variant
TotalSheets = Worksheets.Count
Sheets("Invoice").Select
Sheets("Invoice").Copy After:=Worksheets(TotalSheets)

ActiveSheet.Name = Range("G3").Value
End Sub

[compariniaa]

worksheets.add
activesheet.move after:=activesheet 'or _ sheets(worksheets.count)

[jungix]

It worked with the second one:


ActiveSheet.Move after:=Sheets(Worksheets.Count)


But not with the first one. Thanks anyway.