Make one empty row only between tables.

  • hi,

    can you help please with VBA to remove any extra empty rows between the tables. and keep a fixed number of row , say 1 row only. so all the vertical separation between tables will be the same.

    please check the attached file.


    there is actually more than two columns of tables ,but i give sample of two.


    highly appreciate you help.

    thanks in advance.

  • Use built-in Excel Tables. Then when a new table row is inserted, or a row deleted, the tables below the Table where the row was inserted or deleted will automatically move down or up accordingly. Thus maintaining a constant gap between each Table.


    I am attaching your workbook with the right hand tables converted to built-in Excel Tables. Note I have also removed the bottom row of each table and replaced it with a Totals Row, that Total will adjust automatically for all changes made to a Table.

    Files

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • If you are still after a macro solution, I think this does what you are after - try the button on the sheet.


    SampleTables w macro.xlsb