Excel convert Range to Array in VBA
Arrays have more powerful options than simple Excel ranges but, happily, it’s very easy to convert a range of cells into an array. Or sometimes you have a mix of arrays and ranges that need to be managed as a collection of arrays. That’s what we’ve needed to make the NetworkDays() and NetworkDays_Intl() functions work […]