I am writing a program in VBA in Excel, which allows the user to insert a new worksheet. Is there any way of knowing what the new sheet number will be if the user can insert a number of new sheets at any time. Obviously, once Excel is opened a new sheet starts as Sheet1, however I need to know after a number of new insertions what the sheet will be called.
The best option would be to right click on the Sheet tab and rename it, so you would always know what it is. You could then use a function like =sum(sheet name,!a10:!x70). Lok under Link in excel help for more information Terry