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

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.