Excel Macro

[jerry chapman]

How can I find the sheet names for an Excel program, by using a macro?

 

[Harald Staff]

Sub test()
Dim sh As Object
For Each sh In ActiveWorkbook.Sheets
MsgBox sh.Name
Next
End Sub

HTH. Best wishes Harald

 

[Myrna Larson]

What do you mean "sheet names for ... program"? Sheetnames relate to a
workbook, not to a macro code. Or do you mean Module names?

If the latter, I believe you can find help on using routines in the VB
Extensibility library by going to www.cpearson.com.