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

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