Tag Archives: UDFs

Returning Arrays From VBA and Python

Posted on 01/06/2018 by dougaj4

Most  of the  user defined functions (UDFs) presented on this blog return a multi-cell array, that must be entered by selecting the output range then pressing Ctrl-shift-enter to display all the results.  This process has several inconveniencies: You need to know … Continue reading →

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings | Tagged , , , , , , , | 1 Comment

JavaScript UDFs in Excel

Posted on 09/05/2018 by dougaj4

Bleeping Computer report that Microsoft have announced JavaScript UDFs for Excel. See the link for more details. This feature is not yet available in standard Excel, but a preview version is available to those joining the Office Insiders Program.

Posted in Excel, Javascript, UDFs | Tagged , , , | 1 Comment