| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
marco to move a sheet
there are more than one sheet in my workbook. i need to move "sheet 23" to
the first sheet. other then sheet 1, first sheet means "sheet 23" appears in the 1st position in sheets tab bar, number of sheets and name of sheets are uncertain. -- Dennis Cheung |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
marco to move a sheet
Hi Dennis,
Sheets("Sheet23").Move Befo=Sheets(1) Also if Sheet23 is the Active sheet then can use ActiveSheet in lieu of Sheets("Sheet23") in the above code. -- Regards, OssieMac "Dennis Cheung" wrote: there are more than one sheet in my workbook. i need to move "sheet 23" to the first sheet. other then sheet 1, first sheet means "sheet 23" appears in the 1st position in sheets tab bar, number of sheets and name of sheets are uncertain. -- Dennis Cheung |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Marco - I need to trim/move the text from the beginning of each ce | Excel Programming | |||
| HOW CAN I ADD BUTTON ON SHEET AND LET MARCO RUN? | Excel Discussion (Misc queries) | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| write marco to put data from sheet to memory | Excel Programming | |||
Linear Mode
