Sub Declaration

Hi,
In the first version, you need to declare, set and then pass values to the sub to make in work, something like:

Sub Test
dim Your_Array as Variant
Dim Your_Range as Range

Your_Array = Something
Set Your_Range = Something

Call ReadArrayFromExcel(Your_Array, Your_Range)
'or
ReadArrayFromExcel Your_Array, Your_Range
End Sub

While in the second version, you declare and set your variable in the sub directly.