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.zip
Transferring data within VBA discusses alternatives for transferring data between VBA routines.
Download: http://interactiveds.com.au/software/ByRefByVal1.xls
Calling a function as a variable describes how to call another function in VBA as a variable, rather than having the function name hard coded.
Download: http://interactiveds.com.au/software/PassFunc.xls
Getting the address of a selected range does what it says.
Download: http://www.interactiveds.com.au/software/RngAddress.xlsb
Finally Writing Arrays to the worksheet – VBA function provides an efficient VBA function to write data from VBA arrays to the worksheet, with several useful options.
Download: http://www.interactiveds.com.au/software/CopyToRange.xlsb