Hi

When you talk about adding rows to the table, do you mean a named range ?

If so there are a couple of ways to solve the problem, a dynamic named range which expands as you add data, or with a fixed range you need to make the range one row bigger at the top and then hide that row and then when adding rows, start from the second row and the range will expand as each row is added.

If you have a small example you can post it will be possible to make the changes for you to see.

Regards

Jeff