Tag Archives: Arrays

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

Daily Download 30: Data Transfer, to and from VBA

Today’s downloads cover procedures and functions for the transfer of data between VBA and the spreadsheet, and within VBA. Array resources provides a variety of resources and web links covering the transfer of data on the spreadsheet to VBA arrays. Download: http://www.interactiveds.com.au/software/getarray.zipContinue reading

Posted in Arrays, Computing - general, Excel, UDFs, VBA | Tagged , , , , , , | Leave a comment

Transferring data with arrays

The earlier post: Transferring data within VBA looked at some important aspects of transferring data between subroutines in Excel VBA.  This post will look at arrays in particular, and some peculiarities that affect the way they work. VBA arrays are a very … Continue reading

Posted in Arrays, Excel, VBA | Tagged , , , , , , , | Leave a comment