Error putting horizontal series of cells into array .....why?

Those two ranges are the not the same the first M2:Y2.

Is month_array1 declared as a variant?

Mistake on my part the two ranges are as follows:

Please Login or Register  to view this content.

Now the ranges should be the same but again month_array1 has a runtime error.

I defined both month_array1 and month_array2 the same as variants such as this

Please Login or Register  to view this content.

I still dont know why the first one does not work.

Duh............ok........i am an idiot.

Ok. B2 to B25 is obviously not the same as Cells(2,13) through Cells(2,25).

both seem to work now..........

Please Login or Register  to view this content.