![]() |
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. |
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. |
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