Hello
How can I do this? :

Im trying to set the values of a group of cells to an array.
Set rng2 = Array(Range("B4" & .Value), Range("B5" & .Value))
The actual range is B4:I4, but I cannot even get it to work with 2 cells. I
tried set rng2=Array(Range("B4:I4").value, but Im sure ya'll know that did
not work either.

Thank you so much
Terry V