listbox to table array continually missing last row

[nigelog]

Have a 7 column listbox that is written to a table in batches. Im not the best with arrays or table and cant figure why, no matter how many entries are in the listbox, when it is copied across the last entry is always missing. Tried many ways to do this
Im pretty sure that the data is in the array

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Richard Buttrey]

Sounds as though it's a conflict between the index number for the listbox items and the Base you've chosen for VBA. i.e. If you've not set
Option Base 1 then the default will be Base 0.

However upload the workbook and describe how you use it so that we can understand further.

[nigelog]

Sorted Richard using row count to set array, thanks

Please Login or Register  to view this content.