Write array to destination stops at row 3699

[sonicroc]

I am pretty confident this is a new problem.
Recently a routine I wrote started behaving strange in my investigation in found that when I write and array of data to either a range or table that it is only providing data up to row 3699.
It is consistent whether I write to a table or range. Yes, I am adequately re-sizing the range or Table for the incoming data. The array is 1 to 15777r by 1 to 35c.
---Sample---
Set drng = Worksheets("Tickets2").Range("A1").Resize(UBound(tktA, 1), UBound(tktA, 2))
drng = tktA


tkt_T.DataBodyRange = tktA

 

[Fluff]

Are you sure that the array contains data below row 3699?

 

[sonicroc]

Are you sure that the array contains data below row 3699?

absolutely.

 

[Fluff]

In that case how are you populating the array?

 

[sonicroc]

In that case how are you populating the array?

I am taking data from multiple tables into arrays then looping through it all to correlate it all into one table based on a common index (i.e. ticket#)
example...
For k = 1 To C2
If tktA(i, 2) Like ctktdA(k, 2) Then 'ticket id
tktA(i, 13) = ctktdA(k, 9) 'Requestor
tktA(i, 16) = ctktdA(k, 3) 'Title
tktA(i, 17) = ctktdA(k, 4) 'Problem description
tktA(i, 18) = ctktdA(k, 5) 'Solution
tktA(i, 19) = ctktdA(k, 6) 'Solution Description
tktA(i, 20) = ctktdA(k, 7) 'Bug ID
tktA(i, 21) = ctktdA(k, 8) 'Company Name
GoTo NK:
End If
Next k

 

[RoryA]

How have you verified that there is data in the array below row 3699?

 

[sonicroc]

How have you verified that there is data in the array below row 3699?

stepping through and looking at the array while in break.

 

[sonicroc]

I should note, I have even created a new file copied data to it, copied, not exported module with my code and re-tried it. tried deleting and re-creating table/sheet etc..

 

[sonicroc]

I believe it is a cell that contains this string that is causing the issue.


"============================================


config system virtual-wan-link


config members


edit 6


set interface "wan2"


set weight 1


set gateway x.x.x.x <-----------------------------------


next


end


=============================="

 

[sonicroc]

Should I try to enforce formatting in someway when moving the data either in or out of the Array to fix this? It looks like it is the "======" of course.