Home
VBA / Excel / Access / Word
Access
Application
Data Type
Data Type Functions
Date Functions
Excel
File Path
Forms
Language Basics
Math Functions
Outlook
PowerPoint
String Functions
Windows API
Word
XML
Array Function « Data Type « VBA / Excel / Access / Word
VBA / Excel / Access / Word
Data Type
Array Function
1.
Using the Array Function
2.
The LBound and UBound functions return whole numbers that indicate the lower bound and upper bound indices of an array.
3.
avoids the error "Subscript out of range"
4.
Use IsArray function to check if a variable is an array