If truth be told, my own introduction to the EXPAND function could be termed slightly mystifying. In his preview of Excel’s second-generation dynamic array functions, Microsoft developer Joe McDaid tells us that “EXPAND allows you to grow an array to the size of your choice—you just need to provide the new dimensions and a value to fill the extra space with.”
Apart from dangling a preposition, that description left me ever-so-slightly clueless. Exactly what does growing an array (or range) mean, and more to the point, what ...
