I am trying to use the code for sorting worksheets by a named array
from this website
http://www.cpearson.com/excel/SortWS.aspx
Sub SortMySheets()
Dim NameArray As Variant
NameArray = Range("mysheets").Value
'Looping structure to look at array.
For i = 1 To UBound(NameArray)
MsgBox NameArray(i, 1)
Next
SortWorksheetsByNameArray (NameArray()) <== I keep getting errors
here, think i have tried almost everything
End Sub