Hi Don,

So stopping and
stepping through is useless for debugging. It will always work.
What's up?

did you try to save the workbook under a new name (save as), then "open
and repair" (from Excel XP and later)? Try to create a new module/form
(whatsoever) in VBE and copy all your code there and delete the old
module. I remember having this problem cause by a corrupt Excel file.

But still, are you sure your connection to Access works correctly? Try
to pause your macro with application.wait (or maybe a dummy loopt with
do events). What happens, if you fill your list manually instead of the
access connection (like test1, test2... test10)?

regards

arno