Tag Archives: array functions

Using VBA Evaluate as an Array Function

I recently discovered from a thread at  Chandoo’s Excel Forum that the VBA Evaluate function can be used as an array function.  As a simple example: Range(“A11:A16”).Value = Evaluate(“= B11:B16 + C11:C16”) will add the values in columns B and C, … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , | 2 Comments

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

Writing an array function from VBA

I have covered the topic of writing VBA arrays to a spreadsheet range quite frequently here.  As a reminder, the procedure is: ReDim myarray(1 To NumArrayRows, 1 To NumArrayColumns) ‘ Fill array With Range(“MyNamedRange”) .ClearContents .Resize(NumArrayRows, NumArrayColumns).Name = “MyNamedRange” End … Continue reading

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 1 Comment

Using Excel’s shortest functions

Happy New Year to everyone. I’ve been busy working on a 3D version of my frame analysis program (which will be published in the not too distant future), but as things have been a bit quiet here recently, here are … Continue reading

Posted in Arrays, Excel | Tagged , , , , | 26 Comments