Adding line tot able & Writing to excel sheet through Array

Hello everybody,

I am working on some sort of excel ledger at work. When you initialize it, it grabs data from a text file, processes it and inserts it in a pre-made table. I'm having some issues with two subroutines in particular that are called during this whole process. They are the subroutines that add lines to the table (so were sure there are enough in the table to take the data we are going to feed it) and the one that takes the array I had prepared from the text file and writes it out in the table. Here they are:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have verified with countless Debug.Print calls and re-runs. The procedures are called, they run to the end, the array & the range have the exact same size, the array does contain data, the array is a Variant type, but somehow those two actions (adding lines and pasting the array) are never done. Everything else works just fine. I don't even get an error or anything like that, the lines are just ignored. Even worse, when I write a dummy subroutine to set up a dummy array and feed it to Populate_TC85, everything seems to work fine. I kind of am at my wits' end here.

The only thing I could imagine (I'll test it out tomorrow) is that maybe it's because my array contains varied data types (strings, numbers, vbNullStrings...), while the dummy array I created to test only contained strings...?

Does anybody have a stroke of genius of why that might be?

Thanks a bunch in advance!

Oh I didn't know the F8 thing, will definitely try that out tomorrow, see if I can find out more, thanks!

About the header row thing in the count of rows: it's because the table doesn't start at line 1 of the sheet and RowPosition is the relative position in the table, not the absolute row on the sheet.

I'll see if I can post a larger chunk of the code but I'm not super sure I'm allowed to share the whole workbook as it's a work thing. Besides I'm in the process of cleaning it up and there's a lot of confusing loose ends in various places (there shouldn't be in this part of the code however).

Sorry if double-posting in frowned upon here, just chiming in to say I've figured out my problem. Basically it -was- working but it was not adding rows & inserting the data on the sheet I was expecting it to. It was an easy fix once I figured that out.

Thanks for the F8 trick, it's what really helped me find out the problem, I'll definitely remember this in the future!