Run Time Error 1004 within Array

Hi All,

I'm running the code below and it all seems to work fine until the 25th cycle (of R) through (in the data set i'm using for testing there should be 28 cycles), where it'll stop at the line .Range("A2").Resize(N - 1, UBound(Arr2, 2)) = Arr2
giving the error message Run-time error '1004': Application-defined or object-definition error. I'm a little baffled by this as all this line is doing is pasting data from the array into the worksheet (something it did successfully the previous 24 cycles). I've ran this a few times and it always stops at the same location.

Anyone have any idea why this might be?

Please Login or Register  to view this content.

WOW! protonLeah thank you so much for your help! it's so obvious once someones kindly pointed it out to you.

just had to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and looks to have solved "this issue", think I have another one but just looking into that now.

thank you so much for your assistance.