Move a particular named sheet to the end.

[Ann]

Using macros, how can I move a sheet called TOTAL to become the very last
sheet within a workbook?

Your assistance will be appreciated.

 

[Barb Reinhardt]

Try this:

Worksheets("Total").Move after:=Worksheets(Worksheets.Count)

 

[Ann]

Barb,

Works a treat, thank you for your assiatance.