ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Macro Question (https://www.excelbanter.com/new-users-excel/79140-macro-question.html)

Greg

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

Thanks

Greg



Stefi

Macro Question
 
Record a macro and you'll see it!

Regards,
Stefi

€˛Greg€¯ ezt Ć*rta:

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

Thanks

Greg




flummi

Macro Question
 
right click on the sheet tab
select "Copy or Move"
then select "Move to End"

Regards

Hans


Stefi

Macro Question
 
Hi 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


€˛flummi€¯ ezt Ć*rta:

right click on the sheet tab
select "Copy or Move"
then select "Move to End"

Regards

Hans



[email protected]

Macro Question
 
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



All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com