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

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

HTH. Best wishes Harald

"jerry chapman" skrev i melding
m...
How can I find the sheet names for an Excel program, by using a macro?

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.


On Sat, 19 Feb 2005 22:32:47 GMT, "jerry chapman"
wrote:

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