Runtime Error: run time error -2147417748(80010108)

So im trying to create a data base with userforms and worksheets. Inside the worksheet, ive got a table where everytime I fill up textboxes, comboboxes etc. and click a button (everything inside a userform), the information within these objects is being saved in a new row under the table, and it becomes part of the table, but different columns, in the existing table.

Right now Ive got a table with 100 rows and 63 columns. EVERY COLUMN IS FILLED WITH SOMETHING WHEN I CLICK THE BUTTON IN THE USERFORM.

while testing, I had like 40 columns and everything was fine, I could create a new row at the bottom of the table and save the information Then, I added more columns until having 63.

Now when I want to save the information, this error pops out:

method cells of object _worksheet failed

Apparently an automation error (which I have no idea what does that mean)

So doing research, it might be something about connection issues or the size (kb) of my userform, or my userforms being ShowModal:=True.

I set my userforms to Showmodal:= False, the size of my userform is no more than 35 kb, and as my understanding, the max size can be up top 64kb, so I dont think that's failing.

When reviewing my table, I added a blank extra row manually and the error is gone. Seems like the program isn't recognizing any cell outside my table, which it did when I was testing with 40 columns, and is provoking this error.

BUT... I didnt change the code when adding the columns, when I had 40 columns, everything worked, I even tried to explicit add a new row to my table and write on that row, but the same error keeps popping. Could be a loop somewhere?

IMPORTANT INFORMATION: Every userform is set to ShowModal:= False, I have 15 userforms, right now i have 100 rows and 63 columns.
Hope you can help, I've been trying to solve this issue for weeks

Here's part of my code to write on the worksheet:

Please Login or Register  to view this content.

So let's say I have 100 rows in a table. With a button and the exact same code I posted previously, I added those 100 rows. Now when I try to to add a new row with values in the table, there's this Automation Error but now, with the message "method default of object range failed". So because table ends at row 100, the app thinks im sending a wrong address to write values. I want to write on line 101, but because it isnt within the table, I get the error. Previously, when I wrote below the table, that new row became part of the table, just as I wanted to be.

I solved the last error message "method cells of object _worksheet failed" by assigning object variables to workbook and worksheet.

Did you make the changes I suggested just to see if it makes a difference?

When the error occurs, do you have the option to enter debug mode? If so, what line of code does it stop on? What is the value of final when the error occurs?

Yes I applied the changes, but those weren't the cause of the error as we already knew. I've got the option to debug. When I click Debug, the line where the error pops is this one

'GRABAMOS ALTA NUEVO CLIENTE
Worksheets("BaseDeDatos").Cells(final, 1) = ufNuevoCliente.tb_NumeroCliente.value 'ERROR LINE

the final value is 102, as expected due to the headers of my table and having already 100 rows of data. The "method cells of object _worksheet failed" error was solved assigning variables as workbook and worksheets. Now Im getting this one "method default of object range failed", as I explained in my last rep, I dont know why Cells function is only accepting an address within my table, I cant add a new line of values.

Maybe not a solution, but to get a better idea, if I grab the corner of my table in my worksheet, and I pull it down one row (add one row covering line 102), AND THEN I run the code, it succeeds. But obviously im not doing a manual resizing everytime I want to add data to my table

Hello,

I Know it's been a time, but I've got the same problem when adding new rows with the "add" method.

How were you able to solve the problem?

I really appreciate your kind answer.

Thanks a lot!