sheet names in cells.. also macro names came...
Posted by Pasi Vartiainen on April 16, 2000 11:56 PM
I have macro, which code is found in this excelent message board:
Dim sh, x As Integer
For Each sh In ThisWorkbook.Sheets
Cells(x + 1, 1) = sh.Name
x = x + 1
This macro writes sheet names to cells. The problem is that this macro also writes "modele"", "module2", etc. to cells. So, it also sees macros.. is there any easy way to prevent macros "module1" to print to cell?
Preventing module seen isn't vital, but it looks kind of silly...
Waiting for answers..