Be the first user to complete this post Login To Mark Completed

0

Add to List Add To List..(Max 5) Close Save

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 

---

---

Also Read:

1. VBA-Excel: Delete Blank Rows from Excel Work Sheet
2. VBA-Excel : Strings Functions – Right
3. VBA-Excel: Select and Activate Cells - Select
4. VBA-Excel: Create Array using Array() Function
5. VBA-Excel: Cells Ranges Offset - Active Cell
6. VBA-Excel : Strings Functions – InstrRev
7. VBA-Excel: Date-Time Functions – IsDate()
8. VBA-Excel: Date-Time Functions – DatePart()

---