Runtime Error: -2147417848(80010108) - Method '_Default' of object 'Range' failed

Hi there

I have created a user form that allows the user to input some text fields and use dropdowns to select other field entries and then saves the data to a data table.

The problem I'm having is that it works perfectly for me, it was working for her and now for some unknown reason when she wants to save the data, she gets this error. She hasn't changed anything and neither have I and there isn't any bad data as I've checked it.

When I ask her to click Debug on the error message, it very briefly pops up where the error is occurring but then shuts down the whole excel application. I have added the code in which the error is being indicated and as I said in my intro I'm a beginner so it may not be well written but it works...at least for me it does.

I am at a complete loss as to where to even begin to look for the problem.

Does anyone have any ideas for me please?

Many thanks
Ursula

Apologies, brain not in gear. I will do that now.
Thank you

File attached now.

I have attached the file now but I have no solution as the code works perfectly on my computer. That's my dilemma. 😫

I have solved this problem by inserting more rows into the existing table. That seems to have fixed the issue on the user's computer. This can now be marked as solved.