user758114
user758114

Reputation: 354

Call a Var returning function from one worksheet from another

I have a variable returning function in one worksheet That I wish to call from another worksheet. How do I do this?

Function DoUntilOption() As String()
 Dim array1(10) As String
 Dim matrix2(10, 10) As String
...Processing matrix2...
 DoUntilOption = matrix2()
End Function

Upvotes: 0

Views: 45

Answers (1)

user758114
user758114

Reputation: 354

I figured it out;

   matrix = Sheets("NameofSheet").DoUntilOption

Upvotes: 1

Related Questions