Be the first user to complete this post

  • 0
 Add to List

VBA-Excel: Array Functions – IsArray()

Description:

 IsArray() Function determines whether the specified variable is array or not and based upon that returns the Boolean value.

Format:

IsArray(varVariable)

Arguments:
  • varVariable
    • Manda­tory
    • IsArray() function evaluates this string.


Example:

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()
IsArray()




    

    


        

            

              
                
                
            

          

        

    

    
         
Also Read:


  
    

    
     
          
  1. VBA-Excel: Date-Time Functions – DateDiff()
    2. 
      
    
     
          
  2. VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
    3. 
      
    
     
          
  3. VBA-Excel: Arrays – Two Dimensional, Static Array
    4. 
      
    
     
          
  4. VBA Excel - Cells, Ranges and Offset : Cells
    5. 
      
    
     
          
  5. VBA-Excel: Arrays – One Dimension, Dynamic Array
    6.