Add Elements to a Dynamic Array Variable in VBA
2,019 views · Published 30 November 2010 · 0:56 · Indexed 7 October 2026
Channel: TeachExcel · 2010 · Education
Go to http://www.Teachmsoffice.com to view all of this tutorial. This Excel VBA macro tutorial shows you how to add elements to a dynamic array variable in VBA. This tutorial will also cover how to prevent previous elements in the array from being erased when you add a new element to the array. This is especially important when you need to increase the size of the array in order to add an extra element or multiple new elements to the array, which is also covered in this tutorial.
