VBA runtime error, Listrows.Add

[Sid1120]

Has anyone ever run into this problem before?

I have an extensive .xlsm which uses the simple command line :

ThisWorkbook.worksheets(1).listobjects(1).listrows.add

And 2 out of 3 times, it will cause a run-time error which will then crash Excel and restart it.


The full piece of code is as follow (however even the simple example above bugs):

Dim iTable As ListObject
    Dim newRow As ListRow
    
    sheetsArray = getSheetsArray

For Each iSheetName In sheetsArray
        Set iTable = ThisWorkbook.Worksheets(iSheetName).ListObjects(1)
        
        Set newRow = iTable.ListRows.Add(Position:=iTable.ListRows.Count + 1)
        
        transferDataToRow newRow, iTable
Next iSheetName

Has anyone ever had this bug, which seems to be more of an Excel instability then an error with the code?

Any solutions? The fact that I cant add listrows to listobjects seems pretty disastrous!