View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mac Lingo[_2_] Mac Lingo[_2_] is offline
external usenet poster
 
Posts: 53
Default VBA: How to pass arrays in Function Calls?

This code dies at the "Msgbox" Line.

Can you give me an idea why. And what do I do to make it work as it should?

Function Testx(Arg)
' Function should return the word "Won".
Dim Cols(3) As Integer
Call Testy(Cols())
Testx = Cols(1)
End Function

Sub Testy(Cols() As Integer)
Cols(1) = "Won"
MsgBox "Done" <-- Calling never gets to this line.
End Sub

Thanks,
Mac Lingo
Berkeley, CA