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.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

This entry was posted in Arrays, Computing - general, Excel, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.