marco to move a sheet

D

Dennis Cheung

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.
 
O

OssieMac

Hi Dennis,

Sheets("Sheet23").Move Before:=Sheets(1)

Also if Sheet23 is the Active sheet then can use ActiveSheet in lieu of
Sheets("Sheet23") in the above code.
 
Top