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
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