Be the first user to complete this post
|
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
- Mandatory
- 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:
- VBA-Excel: Date-Time Functions – DateDiff()
- VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
- VBA-Excel: Arrays – Two Dimensional, Static Array
- VBA Excel - Cells, Ranges and Offset : Cells
- VBA-Excel: Arrays – One Dimension, Dynamic Array