Trying to do anything complex with VBA arrays is like banging your head on a wall but without that satisfying feeling when you stop. Because of this, I created this class to do the nifty stuff I can ...

This is essentially a rewrite of Charles H. Pearson’s http://www.cpearson.com/excel/vbaarrays.htm. Thank you for the great work! This repository exists to bundle ...

To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...