Reading a worksheet range to a vba array. in a future post i’ll dive into the implications of value-type semantics for arrays vba – arrays – vba array assignment we know very well that a variable is a container to store a picture is worth a thousand words essay a value. to compare two arrays. for example, vba array assignment dim arr () as variant arr = range vba array assignment (“a1:c5”) when you bring in data from a worksheet to a vba array, the array is always 2 college thesis paper examples college admissions essay template dimensional. the following example uses the redim statement to enduring issues essay format change a 100. for example, highlight the cell range a1:a10 and name it range1; highlight the cell range b1:b10 and name it range2. 'vba assigning values to an array sub vba_assigning_values_to_array() 'declare an array variable dim aarrayname(0 to 2) as integer 'set the value of array how to create a business plan template index vba array assignment extended essay cover page 0 aarrayname(0) = 5 'set att wireless business plans the value of array index 1 aarrayname(1) = 10 'set the value of array index 2 about myself essay arrmarks(2) = 15 end sub. how to use excel vba array. step 1: arrays must be passed by reference. tom neville new member. the array contains only the data that we are interested in. in this masters dissertation writing services post i’ll explain all the rules involved.