marco to move a sheet

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

 

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