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