Can a Function return an Array

[jmsrickland]

I have several functions that need to return an Arrays.

Can this be done without having the array as a ByRef argument in the argument list

'How I do it now:

Private Sub SomeSub()
  '
  '
 Dim MyArray(10) As Integer
 
 UpdateArray MyArray
  '
  '
End Sub
  '
  '
  '
Private Function UpdateArray(ByRef CallersArray() As Integer) As Integer
  '
  '
  '
End Function

Something how I would like to do it:

Private Sub SomeSub()
  '
  '
 Dim MyArray(10) As Integer
 
 MyArray = UpdateArray()
  '
  '
End Sub
  '
  '
  '
Private Function UpdateArray() As Integer()
  '
  '
  '
End Function