Katamesff

To list the sheet names in a workbook, we will do the following Create a named range "Worksheets" Use a formula to list out all sheet names Create Name Range for Sheet Names To create a Named Range for the sheet names, in the Excel Ribbon Formulas > Name Manager > New Type "Worksheets" in the Name Box I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B Is it possible to enter all the names in list A and search it against the list of names in list B in one go? I'm using VS10 Office Interop 07 to attempt to get a few specific spreadsheet names from an Excel spreadsheet with 56 pages All I am doing from there is saving those few spreadsheets I need in a tab delimited text file for further processing So for the three spreadsheet names I get, each one will have its own tab delimited text file How To Use Vba Procedures To Generate A List Of Sheet Names In An Excel Workbook Te