I'm trying to make an array that is a list of all the worksheet names in my excel document, this script seems close but doesn't quite work, instead it lists a seriies of references to various cells, can you please help?
Dim WSheets() As String
Dim iCount As Integer
Dim Max As Integer
Max = ThisWorkbook.Sheets.Count
ReDim WSheets(1 To Max)
For iCount = 1 To Max
WSheets(iCount) = ThisWorkbook.Names(iCount)