• Home
  • VBA Tutorial
  • VBA Cheat Sheet
  • Excel SQL Add-In
  • VBA Time Saver
  • VBA Web Scraping Kit
  • Excel LOOKUP Wizard
  • Merch

Analyst Cave

Simply the best place to learn Excel and Analytics

  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video
  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video

Home » VBA Function – Reference of VBA Functions » VBA Array Functions

VBA Array Functions

Below listed are Excel VBA Array functions:

VBA Array Function
VBA Erase Function
VBA Filter Function
VBA IsArray Function
VBA Join Function
VBA LBound Function
VBA ReDim Statement
VBA UBound Function

VBA Array

Other Array resources

Below please find other useful VBA Array resources:

  • One Dimensional vs Multidimensional Arrays
  • VBA Fixed Arrays vs Dynamic Arrays
  • Merging VBA Arrays
  • Comparing VBA Arrays
  • Sorting VBA Arrays

Download VBA Time Saver

VBA Time Saver Kit

Ready VBA Code snippets for Arrays, Strings, File Dialogs, Read/Write Files, Timers, Progress Bar

Download LOOKUP Wizard

Excel Lookup Wizard Book1

Lookup data from external Excel files and worksheets with the Excel LOOKUP Wizard AddIn!

Articles