Bonjour,

Comme ceci:

Private Function GetSheetNames() As String()
Dim I As Long
Dim aSheetNames() As String
For I = 1 To ActiveWorkbook.Sheets.Count
ReDim Preserve aSheetNames(1 To I)...