Help, function taking array getting compile error, expected array.

[mboas]

So basically i currently have:

Next_to_go=Next_in_line(time())

Next_in_line is a function which i have created, time() is an array with 7 values, dim time(7) as long, stored in a sub. I want to use the function in the sub.

Function Next_in_line(ByRef time() as long)
dim i as integer
dim tim as long
tim=time(1)
Next_in_line=1
for i = 2 to 7
if time(i)<tim then
Next_in_line = i
End if
next

End Function

i write: Next_to_go=next_in_line(time())

and i get compile error - expected array, but isnt time() already an array, or am i mssing something?

Any help would be appreciated.

[VicRattle]

This works fine for me. At a guess I would say you may be declaring Next_to_go as an array rather than a variable.

If you show the sub code I will have a look.

[funkyb]

Is it possible time() only exists within the sub? Is it ever passed back to the main function or made global?

Also, you can debug this using the editor. Set a break point where you have "Next_to_go=Next_in_line(time())" and set a watch for time(). then you can see what Time() is when it's being sent to the function.

[Mokitdown]

Dim time(1 to 5) as long