I would like to create a macro in excel to automatically insert a new blank row immediately after the last row of filled-in data and for this newly inserted blank row to be formatted (including conditional formats) as the filled-in row before it.
Can you please tell me the macro code that would achieve this?
Thank you very much in advance.
Excel macro add row to bottom of table
Excel macro insert row at bottom of table - Best answers