Enter SheetNames into the Name field, enter the following formula into the Refers to field =REPLACE(GETWORKBOOK(1),1,FIND("",GETWORKBOOK(1)),""), and then select OKThis action will create a named formula that can then be used in conjunction with the INDEX function to produce a list of worksheet names Continuing, let us assume you have 25 namedQuickly insert all sheet names in cells with VBA If you want to inset all sheet names in cells, VBA macro is a good choice Step 1 Hold down the Alt F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window Step 2 Click Insert > Module, and paste the following macro in the Module Window From cell , fill out the formula below and drag down to list all the sheet names =INDEX(MID(SheetNames,FIND("",SheetNames)1,255),ROWS(A$1A1)) In my example, I don't have Sheet28 and also the sheet name is sorted by the order from left to right Move around and check the result
Return Sheet Name In Cell Excel Formula Youtube
