"SteveM" wrote in message
news:e3e3f6a6-5758-4806-8c64-
A VBA function only returns a single value. But you are trying to
return an array.

Indeed a UDF can return a array to cells

Select a similar size array of cells, with the formula in the input bar
Array enter with Ctrl-shift-Enter

Regards,
Peter T