Retrieve the names of worksheets and display them in a MsgBox
Posted on 2013-12-15
On the currently open workbook I would like to perform the following action using VBA:
Retrieve the worksheets' names of all the worksheets of the currently open workbook with the exception of the sheets named 'Main', 'Calculation' and any sheets with the default names such as 'sheet1'.
The worksheet names are to be displayed in a MsgBox. I know that there is a character limitation on MsgBoxes.
Help is much appreciated. Thank you very much in advance.