| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| Create a sheet name, won't let me, says already sheet named that | Excel Worksheet Functions | |||
| referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
| I would like to move from sheet to sheet in a workbook using keybo | New Users to Excel | |||
| can't move a named cell without breaking a hyperlink to that cell | Links and Linking in Excel | |||
Linear Mode
