Hi All,

I have a table of data with 13 rows and 6 columns. I want to transfer the data from columns 1, 3 and 5 into an array for processing.

I have used the following script:

arrValue = Empty
arrValue = Worksheets(1).Range("B3:B15,D315,F3:F15").Value
RangeToArray = True

I was hoping this would result in an array arrValue with dimensions (13,3) but when I try to access any element in column 2 or 3 I get a subscript out of range error. I thought that maybe the range was being copied as a single column but when I checked rown 14, column 1 I also got an out of range error.

Any ideas where I'm going wrong?

Thanks
Matt