reading a range of cell to a part of an array

[hazmat]

if i have an array like this

ReDim ray(1 to 30, 1 to 17)

how do i read, say, cells (V8:V37) into the array rows 1:30 but only in the 7th column?

thanks

 

[hazmat]

or another option i think would work

when i do this at the end of my code

Range("A48").Resize(30, 7) = ray

how can i not overwrite the values the cells (G48:G77)

thanks