Array, isArray

Cass

New member
Local time
Today, 18:09
Joined
Oct 2, 2004
Messages
7
How to use array and isarray? I'm not good in VBA but i learning ;)
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
 

Users who are viewing this thread

Back
Top Bottom