Ich habe erfolglos nach einem Code gesucht, der mir in eine bestehende Tabelle (in Spalte A, ab Zeile 1) alle Worksheet-Namen ausgibt.
Kann mir jemand helfen?
Danke und Gruss, Peter
Sub Peter()
Dim objSh As WorkSheet
For Each ObjSh In ThisWorkBook.WorkSheets
Cells(objSh.Index,1) = objSh.Name
Next
End Sub
Sub WorksheetAdd()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
On Error Resume Next
Dim objSh As Worksheet
Sheets("dIndex").Delete
Worksheets.Add After:=Sheets("Data")
ActiveSheet.Name = "dIndex"
Sheets("Index").Cells.ClearContents
For Each objSh In ThisWorkbook.Worksheets
Cells(objSh.Index, 1) = objSh.Name
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Next
End Sub