Move a particular named sheet to the end.
 

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

Your assistance will be appreciated.

--
Thank U and Regards

Ann

Move a particular named sheet to the end.
 

Try this:

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

"Ann" wrote:

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

Your assistance will be appreciated.

--
Thank U and Regards

Ann

Move a particular named sheet to the end.
 

Barb,

Works a treat, thank you for your assiatance.
--
Thank U and Regards

Ann



"Barb Reinhardt" wrote:

Try this:

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

"Ann" wrote:

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

Your assistance will be appreciated.

--
Thank U and Regards

Ann