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 – IsDate()
- VBA-Excel: Date-Time Functions - Timer()
- VBA-Excel : 3D-Ranges – FillAcrossSheets Method
- VBA-Excel: Date-Time Functions – FormatDateTime()
- VBA-Excel: Date-Time Functions – DateSerial()