Issue:
I have an excel sheet where table “table_data” is being resized often. There are few bits of information scattered under the table from column A to column D, therefore when table is resized the information is moving with it. The problem is, that cells below the table pull data from another sheet and have these options attached to them:

.WrapText = True
.EntireRow.AutoFit

So when those cell move up, they resize whole line, therefore information to the right of the table looks disastrous. Below is the example of the “table_data”

Question:
Is there a way to lock the information under the table in place? For e.g. if cells which I need to stay in place are starting from A29 to D32, when table mentioned above resized. I want them to stay the same place, instead they go up by the amount of lines removed in the table. Please note table max lines is 22 as shown above. It can only have less lines. Therefore, table will not overlap with locked cells

Solution:
My current idea is to create 2d array data_style(), store data and style information in the array, clear moved cells and then restore data and style to original cell locations. I haven’t wrote the code yet as it seems inefficient and bulky. I’m hoping there’s a better solution before I resort to that. I’ve started learning VBA about a month ago, that’s why I don’t know if there’s any simpler way to do it

P.S. all cells which need to be locked in same location belong to range “A29:D32” and the selection is named “email_ship”