Create an Array from Excel formula

Hi,

Does anyone know how to create an array from a formula without creating a UDF? I am trying this to no avail?

="{"&Col.Header&"Paid"&"}"

**Also tried putting this in Name Manager and using EVALUATE, strangely getting value error.