Tag Archives: array functions

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