Recent Comments
Tag Archives: re-size arrays
Re-sizing Array Functions
The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged array functions, CSpline2, Cubic Spline functions, Excel, re-size arrays, UDF, VBA
4 Comments
Working with array functions
Regular visitors will know that I make frequent use of User Defined Functions that return an array of data, and need to be entered as an array function. This has the advantages that the functions are very flexible in the … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged array functions, Excel, re-size arrays, UDF, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 