Vba create array of strings from range The following macro creates a 2-dimensional array directly from a range. Web. ReDim creates a new array. Arr = Range ("A1:C5") ' Arr is now an allocated array. . Creating a Drop-Down List from Range 1. b>