How To Fill 2D Arrays Easily
I'm sorry I've told you the wrong thing! (Early morning blues)
I've hust tried to see how your posts would help me.......and noticed
I've posted totally the wrong scenario.
My apologies.
Dim testarray()
ReDim testarray(1 To 5, 1 To 256)
testarray() = Range("B9:L9").Value
testarray() = Range("B14:L14").Value
End Sub
This is what my first post should have been where the 2nd line
ovrwrites the array data.
I want to copy 5 ranges into my Array. The length of each range is
identical but not known before hand hence 1 to 256.
Sorry to bother you again. I can do it by copying the ranges to a temp
sheet where they are all coincident and then put them into the array
but want to avoid this if possible.
Cheers Chaps.
Donna
|