View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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