Sirs,
I need a method or VBA to extract or list sheet names of a workbook into a worksheet.
The workbook contains around 5000 sheets named not in a particular order. These sheet names are to be extracted / entered or listed to Sheet1 of the workbook in any of the columns preferably in Column A.
Thanks & Regards.
VENU
I need a method or VBA to extract or list sheet names of a workbook into a worksheet.
The workbook contains around 5000 sheets named not in a particular order. These sheet names are to be extracted / entered or listed to Sheet1 of the workbook in any of the columns preferably in Column A.
Thanks & Regards.
VENU