I just want an array function that returns the worksheet names in an array. It says the function is invalid when I type =names() in any cell. When I just test it in a test sub, it works fine.
Function names() As String()
Dim n As Integer
Dim k As Integer
n =...