Excel Macro to insert a new row

Joper - Jun 15, 2010 at 11:16 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 11:49 AM

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.


2 responses

Blocked Profile
Jun 16, 2010 at 02:00 AM
Check the information it may be help you.......