Combobox addition to Rowsource in dynamic named range corrupting table

I thought I was fairly proficient in VBA but this has me stumped and has cost many many hours without a solution, hence request for help.

my Userform with combobox entries for product checks against the rowsource and if not on the list, is added to the list. the list is a named range in a Table that is used in a data model.

No matter which way I try I am regularly getting a corruption in the table that is home to the named range which is the rowsource... after one or two entries from the userform.

The rowsource is not bound to the worksheet, it is populated at userform_initialize procedure.
(There are 4 combobox drawing from same rouwsource hence the loop through to check each)

debug points to the line at which conbobox value is being entered into the rowsource, though not always - it sometimes just crashes the whole file and everything needs restarting, upon which the table is fine and entry is evident.

I have tried resize, addrow to bottom of table variations and all result in the same core problem of a table corruption that crashes the file.

I am totally stumped and out of ideas. any help appreciated

Please Login or Register  to view this content.

the sub to initialize the rowsource (and the rest of the userform) is below

Please Login or Register  to view this content.

thanks

Thanks Millz,
- I know the .listobjects("table").databodyrange.listcolumns(1).address should work but it aint. giving on Object error. code is running using the named range instead without a hitch until somewhere after the problem kicks in

- changed the ...=ccont.value as per your suggestion and am getting the result I want which is value placed in appropriate place in the named range

... But am still getting the same problem with table corrupting and excel crashing i'm afraid

Have gone back to an earlier version of the file, ie corruption free, replaced code and retried and getting the same problem result

it doesn't appear to be a problem with the code, per se, as it does what is asked but somehow it is conflicting with rowsource because the table is definitely corrupting.

If I remove the Table and just have a range, there is no problem... but the table is needed for powerpivot relationships

any other ideas appreciated. thanks

Thanks for .columns v .listcolumns reminder
Still crashing and yes, have tried recreating the table a couple of times to no avail as yet.

Perhaps better to keep the rowsource and table separate to avoid the problem and link rowsouce range to the table some other way. Not elegant solution but may remove the problem