Move a particular named sheet to the end.

Thread view:

Thread rating:

Ann - 12 Apr 2007 11:04 GMT

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

Your assistance will be appreciated.

Signature

Thank U and Regards

Ann

Barb Reinhardt - 12 Apr 2007 11:36 GMT

Try this:

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

> Using macros, how can I move a sheet called TOTAL to become the very last
> sheet within a workbook?
>
> Your assistance will be appreciated.

Ann - 12 Apr 2007 11:54 GMT

Barb,

Works a treat, thank you for your assiatance.

Signature

Thank U and Regards

Ann

> Try this:
>
[quoted text clipped - 4 lines]
> >
> > Your assistance will be appreciated.

Rate this thread: