Blog Post

Excel Blog
4 MIN READ

Excel Dynamic Array Improvements

JoeMcDaid's avatar
JoeMcDaid
Icon for Microsoft rankMicrosoft
Feb 20, 2019
Since announcing dynamic arrays, we’ve received an overwhelmingly positive response from the community. Being a fundamental change to the way formulas work, we wanted to take some time to gather and ...
Updated Feb 21, 2019
Version 4.0
blog
dynamic arrays
excel
lori_m's avatar
lori_m
Iron Contributor
Mar 27, 2019

PeterBartholomew1: To be more explicit, we can call a DLL function in the normal way from the sheet by first registering the function using:

ExecuteExcel4Macro "register(""msvcrt"",""_strrev"",""cc"",""STRREV"")"

 

and then call it from the sheet with:

=STRREV("hello")

 

If we select the 'STRREV' portion of this formula and press F9 we get the register id of the function (-996147200.) and an ' @' symbol:

=(@-996147200)("hello")

We can then try to apply this method to a list of registered functions in the first column, along with arguments in subsequent by filling down a simple formula. 

 

But if A1 = -996147200 then =(@A1)("hello") doesn't work and other alternatives seem to crash in current versions. On the other hand: =IF(1,+A1)(B1) does work as expected and could be filled down as required.