Tag Archives: VBIndex

Using Index() as an array function

Posted on June 23, 2013 by dougaj4

As promised, this post looks at using the Excel built in Index() function to operate on arrays; it also provides a VBA user defined function (UDF), VBIndex, which simplifies working with arrays within VBA, and also provides improved functionality when … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 3 Comments