Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- 3DFrame - 3D Frame analysis for Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads by category
- Calling Add-in functions from VBA
- Passing variable argument lists from Excel to Python via xlwings
- Using Linest for non-linear curve fitting, examples, hints and warnings
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