hi guys i need what seems so simple but i cant figure it out.

i need an array to hold all the values it finds in column be starting from
range be6 and continuing down wards untill an empty cell is found and then
end the array

can anyone help

rivers