Function to Return Array of Unique Entries in a Range

I have attached a spreadsheet with a UDF to identify unique entries in a range and return an array of only those uniques. However, the function does not work when passed a Named Range, defined by formula (See the Name Manager). It works fine when passed an explicit range reference or an explicitly defined Named Range.

I'm open to better solutions to the problem of returning an array of uniques from a list which may include duplicates. Ideally, any solution needs to be able to handle named ranges defined by formula.

I'm would really like help in fixing my function, improving the speed of my function, or an alternative approach which accomplishes the same thing.

Thank you

See if the functions I posted here helps. http://www.excelforum.com/excel-prog...o-another.html

Try something like:
=IF(SUM(1/COUNTIF(ExplicitName,ExplicitName))<ROW(A1),"",INDEX(ExplicitName,MATCH(0,COUNTIF(D$6:D6,ExplicitName),0)))
as an array formula (confirm with ctrl+shift+enter) in D7 and copy down. You could also use IFERROR to shorten it in later versions of excel:
=IFERROR(INDEX(ExplicitName,MATCH(0,COUNTIF(D$6:D6,ExplicitName),0)),"")

Making the UDFs volatile didn't work. Open to suggestions regarding a combination of standard Excel functions that will return the last non-empty row in a column.

Edit: rereading the question, I tested:
=IF(SUM(1/COUNTIF(RI_LocationConcatList,RI_LocationConcatList))<ROW(A1),"",INDEX(RI_LocationConcatList,MATCH(0,COUNTIF(D$6:D6,RI_LocationConcatList),0)))

and it also seemed to work ok.

I appreciate all the feedback, but the issue is what happens to the Application.Caller properties when a DNR is passed to my function. Application.Caller.Address only returns the upper left cell in these instances, instead of the entire range. Accordingly, both row count and column count will be 1. If you put a breakpoint on the With Application Caller line, you will be able to see the issue. Any thoughts?

The problem is that my UDF (see attached file) is entered as an array function (S-C-E). I use Application.Caller to obtain info about the output range. For some reason, when a DNR is passed to my function Application.Caller.Address only returns the upper left cell, instead of the entire range. Similarly, both Application.Caller.Rows.Count and Application.Caller.Columns.Count return 1.

The attached workbook shows the function's behavior with different types of range arguments (See column headings). If you put a breakpoint on the With Application Caller line, you will be able to see the issue.