How can I correctly implement a user-defined function in VBA for Excel that returns a 2D array?
I'm trying to create a user-defined function in Excel VBA that returns a 2D array, but I keep running into issues when trying to use the output in Excel. I want the function to generate a multiplication table based on an input size. Here's what I have so far: ```vba Function GenerateMultiplicationTable(n As Integer) As Variant Dim table() As Variant Dim i As Integer, j As Integer ReDim table(1 To n, 1 To n) For i = 1 To n For j = 1 To n table(i, j) = i * j Next j Next i GenerateMultiplicationTable = table End Function ``` When I call this function in an Excel cell like `=GenerateMultiplicationTable(5)`, I get a `#VALUE!` behavior. I've tried changing the return type of the function to `Variant` and using `Application.Transpose` to convert the array before returning, but I still want to get it to work. I also thought about using `Application.Index` to output it properly, but I'm unsure how to implement that correctly in this context. Does anyone know how to properly return a 2D array from a VBA function for use in an Excel worksheet? Any insights or alternative approaches would be greatly appreciated!