Excel versions up to Excel 2007 will not allow array constants to be used in data validation (and other places).

I have Excel 2010 but it's not installed just yet. I don't know if the array constant rule applies to Excel 2010 and later. Do you know?