United States (English) Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Office 2010 > Visual Basic for Applications Language Reference for Office 2010 > Visual Basic Language Reference > Functions > IsArray Function
Office and SharePoint development
Office client development
Office 2010
Office 2010
Visual Basic for Applications Language Reference for Office 2010
Visual Basic Language Reference
Functions
Abs Function
Array Function
Asc Function
Atn Function
CallByName Function
Choose Function
Chr Function
Command Function
Conversion Functions
Cos Function
CreateObject Function
CurDir Function
CVErr Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Day Function
DDB Function
Derived Math Functions
Dir Function
DoEvents Function
Environ Function
EOF Function
Error Function
Exp Function
FileAttr Function
FileDateTime Function
FileLen Function
Filter Function
Format Function (Visual Basic for Applications)
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
FreeFile Function
FV Function
GetAllSettings Function
GetAttr Function
GetObject Function
GetSetting Function
Hex Function
Hour Function
IIf Function
IMEStatus Function
Input Function
InputBox Function
InStr Function
InStrRev Function
Int, Fix Functions
IPmt Function
IRR Function
IsArray Function
IsDate Function
IsEmpty Function
IsError Function
IsMissing Function
IsNull Function
IsNumeric Function
IsObject Function
Join Function
LBound Function
LCase Function
Left Function
Len Function
Loc Function
LOF Function
Log Function
LTrim, RTrim, and Trim Functions
MacID Function
MacScript Function
Math Functions
Mid Function
Minute Function
MIRR Function
Month Function
MonthName Function
MsgBox Function
Now Function
NPer Function
NPV Function
Oct Function
Partition Function
Pmt Function
PPmt Function
PV Function
QBColor Function
Rate Function
Replace Function
RGB Function
Right Function
Rnd Function
Round Function
Second Function
Seek Function
Sgn Function
Shell Function
Sin Function
SLN Function
Space Function
Spc Function
Split Function
Sqr Function
Str Function
StrComp Function
StrConv Function
String Function
StrReverse Function
Switch Function
SYD Function
Tab Function
Tan Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
Type Conversion Functions
TypeName Function
UBound Function
UCase Function
Val Function
VarType Function
Weekday Function
WeekdayName Function
Year Function
Expand Minimize
This topic has not yet been rated - Rate this topic

IsArray Function

Office 2010
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Returns a Boolean value indicating whether a variable is an array.

Syntax

IsArray(varname)

The required varname argument is an identifier specifying a variable.

Remarks

IsArray returns True if the variable is an array; otherwise, it returns False. IsArray is especially useful with variants containing arrays.

This example uses the IsArray function to check if a variable is an array.

Copy 
Dim MyArray(1 To 5) As Integer, YourArray, MyCheck    ' Declare array variables.
YourArray = Array(1, 2, 3)    ' Use Array function.
MyCheck = IsArray(MyArray)    ' Returns True.
MyCheck = IsArray(YourArray)    ' Returns True.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.