For clarity...

The Enum approach addresses your issue with identifying fields.

The array approach combined with the combobox index for record ID
and/or fieldname, along with direct action with the worksheet for
add/delete is a very reliable and safe way to manage table structure.
Since the fieldnames and data table defined range names are dynamic,
they'll each adjust to reflect structural changes in the data
worksheet. Once changed, reload the array and continue working with it
until updating the table is needed next.

HTH

--
Garry

Free uenet access at http://www.eternal-september.org
Classic VB Users Regroup
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion