By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 487 - Redim Preserve a(r -2)

This statement is part of the Array section.

ReDim means to Redimension that is to change the size of an array.

The Preserve keyword (Note this is often and interview question) is used to not lose the values in the array. You will typically use this value.

The name of the array is a and it's new size is the value of the variable r minus 2. This is usually to handle header rows.