How to use array and isarray? I'm not good in VBA but i learning 
code is something like this
a is number 1 .... 99
code is something like this
Code:
Public Function Test(a As ?)
Array1(3 to 4)
Array2(5 to 99)
If a = IsArray(Array1) Then
Test = "Text1"
Elseif a = IsArray(Array2) Then
Test = "Text2"
Else
Test = "Text3"
End If
End Function
a is number 1 .... 99