excel - In VBA, how to return an array / or write to cells using a function? - Stack Overflow

excel - In VBA, how to return an array / or write to cells using a function? - Stack Overflow

瀏覽:1242
日期:2025-04-28
You are not allowed to write to non-caller cells directly from a worksheet function in Excel. If you want to use an array function (using the Shift-Ctrl-Enter) you need to change your code to: Function WriteArray() As Variant Dim arr(0 To 2, 0 To 1) arr(0...看更多