Auto insert blank row. (blank copy of row that includes merged cells)

Hi,
I have posted this in another Excel forum, so apologies if it seems familiar but, I've not had much luck with a suitable answer. The attached file shows a very basic sheet for inputting text only, no formulas. What I need the sheet to do is when someone fills the next blank box in the first column the sheet expands by inserting a blank row with the same formatting (the merged cells) as the previous row? I had found some code that inserts a row but unmerges the cells and inserts the row as single cells. Sorry if this is basic but it's been a long time since I played with VBA.

Hi rutts. See if this works for you.

Please Login or Register  to view this content.

Hi. Thanks for the reply. It's heading the right direction The only thing is when you fill the first cell then either tab to or select the cell in the next column it inserts exactly as I want it but it automatically tabs to the cell below meaning you have click back into adjacent cell. Does that make sense?
what I mean is if I fill the first cell than tab to the adjacent cell I want to stay there so I can fill out but jumps the first column in the new roe.

Thanks again for the help.

Change this line:

Please Login or Register  to view this content.

to this line:

Please Login or Register  to view this content.

Genius. Thankyou very much.

My pleasure.