>How move sheet using : Before and After
>
>Ex in VBA:
>
> Sheets("Sheet3").Select
> Sheets("Sheet3").Move Before:=Sheets(2)
>
> Sheets("Sheet1").Select
> Sheets("Sheet1").Move After:=Sheets(3)
>
>
>Thanks
>
>Mario
with oExcel.ActiveWorkbook
.Sheets('Sheet3').Move(.Sheets(2)) && Move Sheet3 before sheets(2)
endwith
As far as I remember there was a problem with 'after'. If I was wrong then syntax would be :
with oExcel.ActiveWorkbook
.Sheets('Sheet1').Move(,.Sheets(3)) && Move Sheet1 after sheets(3)
endwith
Cetin