I have a spreadsheet that has multiple columns with drop-downs as well as data formatting for numbers. I need to have a macro that I can assign a button to that will find the last row with data and then insert an empty row beneath it but keep the drop-downs for the columns and the formatting of the data types in the cells. The sheet has 19 columns. I'm very new to VBA coding. I searched the forum for a thread but didn't find what I needed. Thank you.