ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving worksheet (https://www.excelbanter.com/excel-programming/348673-moving-worksheet.html)

Joe

Moving worksheet
 
How do I guarantee ( or move ) the newly added worksheet to the far right set
of existing worksheet tabs. The workbook may have 3 or 30 existing worksheet
tabs.
I never know what the last worksheet tab name may be.


Gazeta

Moving worksheet
 
try
Sheets.Add after:=Sheets(Sheets.Count)
mcg

Użytkownik "Joe" napisał w wiadomości
...
How do I guarantee ( or move ) the newly added worksheet to the far right

set
of existing worksheet tabs. The workbook may have 3 or 30 existing

worksheet
tabs.
I never know what the last worksheet tab name may be.




Joe

Moving worksheet
 
Yes !!!
Mr G.... this worked PERFECT !
Thank you very much.

"Gazeta" wrote:

try
Sheets.Add after:=Sheets(Sheets.Count)
mcg

UÂżytkownik "Joe" napisaÂł w wiadomoÂści
...
How do I guarantee ( or move ) the newly added worksheet to the far right

set
of existing worksheet tabs. The workbook may have 3 or 30 existing

worksheet
tabs.
I never know what the last worksheet tab name may be.






All times are GMT +1. The time now is 10:43 AM.

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