Tab Name Info

[Calicarrie]

I have several sumproduct formulas referring to a "sheet list" which identifies the tabs I want to include. I would like that list to be dynamic, so if another user takes over the file and changes a tab name, it will update the sheet list with the new tab name. I have written a formula to do this, but it is extremely cumbersome (Mid, left, address, etc, etc). I assume that there is an easier way to get this information. Does anyone know how??

Thanks for any help!
C

 

[doofusboy]

Why reinvent the wheel? Excel already keeps track of worksheet (tab) names for you. Try this code out in your workbook, it should get you started.

Dim ws As Worksheet
 
    For Each ws In Worksheets
        MsgBox ws.Name
    Next ws