Hello
I had a post here which solved my initial problem
https://www.excelforum.com/excel-pro...ml#post5834541
I can now select a range of cells in my UDF and it will spill down the result.
So if I manually enter the formula "=MyUDF(A1:A13)" it spills down as expected.
If I open the dialog and select A1:A13 in the field, only the first cell is populated and the spill does not occur.
It seems that it puts an @ after the equals as the formula appears "=@MyUDF(A1:A13)".
If I remove the @ it works.
How can I tell the function dialog not to put the @ there?
Bookmarks