Converting Values in a Certain Range to an Array

Excel file teaching how to perform Converting Values in a Certain Range to Sequence operation.

Excel Spreadsheet for Converting Values in A Certain Range to An Array

The December address is read using VBA. Values are stored in an array. Blank cells are skipped. The array size is dynamically determined. The result is cleared after processing.

Hope it is useful.