Hello mccrimmon,

Assign the values to the array rather than the cell object . I know that the value of a Range object is the default property, but you must explicitly state this when making an array.
Dim projects as Variant

projects = Range("B12:B16").Value