Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Fitting high order polynomials
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Beam actions and deflections by Macaulay's Method
Recent Comments
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
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 … Continue reading
Posted in Arrays, Computing - general, Excel, UDFs, VBA
Tagged Arrays, data transfer, Excel, GetArray, UDF, VBA, VBA functions
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