Hi All,

This is my first post here so apologies if this has been asked before and if there is something obvious I am missing please let me know.

Onto my question:

I have an excel file with a macro that is used to add extra lines to a number of excel tables and other ares in the spreadsheet which aren't tables.

I use a loop to go through each section in the file and for each relevant section the code that I have is this:

'Insert Row
addRng.EntireRow.Insert

'Copy Formulas and formating from row above

addRng.EntireRow.Offset(-2, 0).Copy addRng.EntireRow.Offset(-1, 0)


The code inserts a line directly below the table and then copies the formulas from the row above to the new line.

Bear in mind that this does this for both rows which are to form part of a table and also other areas which do not form part of a table.

The table should be automatically expanded to include the new line as part of the table and this works for all the tables except for one. And I have absolutely no idea why this would be the case and was hoping one of you guys could be give me some help.

Thanks very much