ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Moving sheet (https://www.excelbanter.com/excel-discussion-misc-queries/33245-moving-sheet.html)

Greg

Moving sheet
 
What is the code to move the current worksheet to the end of a workbook.

Thanks in advance

Greg



Bob Phillips

activesheet.move after:=sheets(sheets.Count)

--
HTH

Bob Phillips

"Greg" wrote in message
...
What is the code to move the current worksheet to the end of a workbook.

Thanks in advance

Greg





Greg

Thanks again Bob

Greg
"Bob Phillips" wrote in message
...
activesheet.move after:=sheets(sheets.Count)

--
HTH

Bob Phillips

"Greg" wrote in message
...
What is the code to move the current worksheet to the end of a workbook.

Thanks in advance

Greg








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

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