Tag Archives: GetArray

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

Ranges and Arrays

Transferring data from a worksheet into a VBA routine, or the other way round, is one of the most frequent tasks carried out in VBA programming.  Fortunately there is a simple way to do it: In a subroutine: Name the … Continue reading

Posted in Arrays, Excel, UDFs | Tagged , , , | 4 Comments