Need to preserve Sub-Header row heights when inserting new rows above and/or below them in Excel



I have a complex Workbook which uses multiple stacked tables to represent 99 specific Modules of data.

So, each table has what I am calling a Sub-Header - it is the Header Row for each table but since there are 99 of them, stacked, eh - Sub-Headers - each is formatted as a 'Header Row' in the custom 'Table Style' made to 'basic' format them, and 'Does my table have headers' is checked.

My problem is this - each Sub-Header Row needs to be Row Height 20, while each Table Row needs to be Row Height 35.

Every time a row is added to one of the tables immediately above or immediately below a sub-header, it copies the sub-header Row Height AND advances all the other tables down the worksheet by one row which pushes their sub-headers into the next Table Row and the previous Table Row into a Sub-Header Row (row height).

Is there a VBA or other solution for this?

Attached Images

Table_Example.jpg (103.7 KB, 11 views)