View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 207
Default automation error 440 when adding to collection

Garry
EmpList is a collection of Employees. Employees is a collection
defined in my Class module as something with a few properties
including badge number, first and last name, and a bunch of man hour
fields. E is short lived employee that comes from a chunk of data and
is added to the collection if and only if it is not already a member
(badge number exists) of the collection. I use this technique a lot
to simply get a unique list of something. It works great, resuming
next and generating a unique collection; until I try to skip a couple
other steps like putting the skipped name in a listbox. There is no
code, or at least no code that I am aware of, to the EmpList.Add. It
is the method for adding to a collection that exists simply by virtue
of EmpList being a collection.
Ken



On Jul 8, 10:09*am, GS wrote:
Can you show the code for EmpList.Add()?

Also, why are you resetting E each time? Seems to me that this might be
causing some conflict since I don't see the connection between Employee
and EmpList.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc