Insert new row at the top of the Table

Hello

I am trying to work out the code to insert a row to a table which is populated with data and drop down lists etc. The data in the table are currently sorted from "Z to A" as i want the last record to be showing at the top of the table. My issue is I want to insert "new record" (new row) in Row 5 directly underneath the table headings however the macro kept copying the formatting (colour etc) of the above row (headings) when I run my current macro. How can I make it stop?

Many thanks in advance

use

Please Login or Register  to view this content.

You can easily change the row no to 1, or 2

Hi AB33

thanks for your reply. That is the code i am using but the issue i am having is that when i do that, the macro will copy the formatting of the row above (in this case table headers) which is not what i want because it is shaded differently to the rest of the table and has different height. Is there a way to make sure the new row has same formatting as the row below and not above?

many thanks

Unless you have some conditional formatting on your sheets, you are only inserting a new row, so I am not sure why is the formatting of any cell is copying in to a new row.