Tag Archives: VBIndex

Using Index() as an array function

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