software

How do I get a sheet to move to the end of the workbook in excel.

Thanks

Greg
Record a macro and you'll see it!

Regards,
Stefi

?reg??ezt ?rta:

gt; How do I get a sheet to move to the end of the workbook in excel.
gt;
gt; Thanks
gt;
gt; Greg
gt;
gt;
gt;

right click on the sheet tab
select quot;Copy or Movequot;
then select quot;Move to Endquot;

Regards

HansHi flummy,

I think Greg wants a macro doing this, because I read his very similar
question among the Programming topics!

Greg, record as a macro what flummi said!

Stefi?lummi??ezt ?rta:

gt; right click on the sheet tab
gt; select quot;Copy or Movequot;
gt; then select quot;Move to Endquot;
gt;
gt; Regards
gt;
gt; Hans
gt;
gt;

Hi Greg

If you want a macro rather than click and drag, try this in a module:

Sub MoveSheet()
ActiveSheet.Move After:=Sheets(Sheets.Count)
End Sub

Regards

Steve