I am just unsure on the syntax of the following problem. I have an function in which I need to pass in a value and then return an array.

```
Function billable(val As String) As Variant()

    Dim arr(1 To 3) As Variant
    arr(1) = Left(val, 1)
    arr(2) = Left(val, 2)
    arr(3) = Left(val, 3)
    billable = Application.Transpose(arr)

End Function

```

My question is, in another procedure how do I get the values from returned billable() array but yet pass the string val into it at the same time?

eg

```
myDesiredValue1 = billable((val),1)
myDesiredValue2 = billable((val),2)
myDesiredValue3 = billable((val),3)

```

Just to point out though, if I have to use an interim array variable, that's not a problem. I gave that approach a go but couldn't work it out either :(

Cheers

Chris