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.
Transferring data within VBA discusses alternatives for transferring data between VBA routines.
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.
Getting the address of a selected range does what it says.
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.