I created a named range which is the result of a user definer function.
Let say my rage is named
List and has three items, if I select three cells and enter
=List and press Ctrl+Shift+Enter, I get my three items in the cells... so everything looks fine.
If I try to use the range as a data validation source (as a list), I get the "Source Currently evaluates to an error".
Is this a limitation of Excel? If not what is wrong, and how can I do?
Public Function testarrayreturn() As Variant Dim Arr(2) As String Arr(0) = "a" Arr(1) = "b" Arr(2) = "c" testarrayreturn = Application.Transpose(Arr) End Function
The named range is defined as