I am evaluating rows in a table.
Going row by row, if a condition is met, I wish to first additem from the first column, then to that item add 12 additional cell values in the following 12 columns.
To eliminate any chance of it having to do with the nature of the cell value, I reduced the data to simple numerical, as shown below.
All runs fine for the first 10 items (the first by additem, then the next 9 by subsequent assignment as shown below) added to the listcount, but no matter what values I try for the next 3 it fails (on number 10). This was verified by when it failed and I selected debug I examined frmRelRecs.lbxRelRecs.List(0,9) in the immediate window and the value was 9.
I have my column count set to 13, even tried 20, but no difference.Please Login or Register to view this content.
Can someone please tell me what am I messing up on?
Many thanks!!!
p.s.: I was considering running an advanced filter on the table, copying it to a temp sheet and using the databody as my rowsource, but for some reason I chose this direction...
Bookmarks