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 , , , , , , | 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 , , , , | Leave a comment