OK, I'm having a problem making a function call from VBA to C++. I'm not even sure if it is possible to do this. Public Declare Function myDllFunction Lib "mydll.dll ...
When I first discovered Excel's dynamic array functions, my entire approach to spreadsheet design shifted. They replaced my clunky, multistep workarounds with smart, self-expanding formulas that adapt ...
Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. The recent article How to generate random letters in Excel shows you how to generate random letters.