How to stop a table from being deleted when setting a range?

[Mutak]

Let's say that cells A1 and B1 contain some values and cells A2 and B2 are empty, but a table is inserted in them.

If we run this code:

Please Login or Register  to view this content.

the table in cells A2 and B2 disappears.

How should this code look like if I want to keep the table?

[sktneer]

What do you mean by table disappears?

Can you upload a sample workbook to see what content actually you have on sheet1? And what is the full code?

[Mutak]

The problematic part of code is part of a bigger project I'm working on and I can't paste the whole code here.
I've excerpted this line as an example and the problem persists when only this line is present, meaning that the problem is not due to other parts of the code.

The workbook with the example is in the attachment. Notice how the table in the cells A2 and B2 disappears after clicking the CommandButton1 button.

[Norie]

What do you actually want to do?

Insert values in the table?

[Mutak]

Yes, I want to insert values in the table.

[sktneer]

Maybe you can try something like this.....

Please Login or Register  to view this content.

[Mutak]

Maybe you can try something like this.....

Please Login or Register  to view this content.

No, this doesn't work because it resizes the table (adds another row). The table needs to keep its original dimensions. After running this code, the table is in range A2:B3 instead of the original range A2:B2.
It partially worked because the table wasn't deleted after running the code.

[xlnitwit]

Hi,

You could write one cell at a time. If your table has more columns, you can write all bar one column using an array and then write the last one. As long as you do not overwrite the entire table at once, it will remain in place.

[Mutak]

Hi,

You could write one cell at a time. If your table has more columns, you can write all bar one column using an array and then write the last one. As long as you do not overwrite the entire table at once, it will remain in place.

The range is much larger and this method would be too difficult for me to code. However, I added a line to sktneer's code:

Please Login or Register  to view this content.

And after this the problem seems to be solved. Thanks everyone.