It worked fine for me with some data I setup, it certainly does not need array-entering.

Can you post the offending workbook, my guess the problem is with the definition of profiledata.