How could the line below so that new sheets are added to the right (instead
of the default left):

Set WSNew = Sheets.Add

Thanks

Oops, it should read as:

How could the line below be amended so that new sheets are added to the
right (instead
of the default left):
Set WSNew = Sheets.Add

don't use both of these, just 2 examples


Sub test()
Dim wsnew As Worksheet
Set wsnew = Worksheets.Add(after:=Worksheets(Worksheets.Count))
Set wsnew = Worksheets.Add(after:=Worksheets("Sheet2"))
End Sub
--


Gary


"Max" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How could the line below so that new sheets are added to the right (instead of
> the default left):
>
> Set WSNew = Sheets.Add
>
> Thanks
>

Gary, thanks for the examples. Very helpful.