Show Buttons
Share On Facebook
Share On Twitter
Share On Google Plus
Share On Linkdin
Share On Reddit
Contact us
Hide Buttons

VBA-Excel: Array Functions – IsArray()

Description:

 IsAr­ray() Func­tion deter­mines whether the spec­i­fied vari­able is array or not and based upon that returns the Boolean value.

Format:

IsAr­ray(var­Vari­able)

Arguments:
  • var­Vari­able
    • Manda­tory
    • IsAr­ray() func­tion eval­u­ates this string.


Exam­ple:

Function FnIsArray()

    Dim arrA(5)

    Dim arrB

  Dim strResult

  strResult = "arrA(5) is an Array: " & IsArray(arrA) & vbCrLf

  strResult = strResult & "arrB is an Array: " & IsArray(arrB)    

  MsgBox strResult

End Function 
IsArray()

IsAr­ray()

 


 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: