Macro to insert blank row below the next fill row

Lacan

Board Regular
Joined
Oct 5, 2016
Messages
163
Office Version
  1. 365
Platform
  1. Windows
Have one sheet for customers which contains in cells:

A2 TodayDate
A3 Feeback
A4 Next Time

In Cell B3 have a blank of 12 cells Merged and Centered.

Now, I require a Macro to execute after filling B3 to insert a new blank row with the same format below B3.

And so on, after filling B4, again, insert a new blank row with the same format below B4 (empty block of 12 cells Merged and Centered).

And so on...

How to do so?

Thanks in advance.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Would you ever be entering anything else into column B on the sheet that you would NOT want to trigger the insertion of a new row?

By the way, merged cells are notorious problematic for things like VBA, sorting, filtering, etc and should really be avoided whenever possible. Note that you can get the same visual affect without all the issues by using the "Center Across Selection" formatting option instead.
See: http://blog.contextures.com/archives/2014/04/10/center-headings-without-merging-cells/
 
Upvote 0
Just find a simple solution.

Thanks again guys.
 
Upvote 0
Just find a simple solution.
Since you were very sparse on providing details, I asked you a question which you did not answer.
Would you ever be entering anything else into column B on the sheet that you would NOT want to trigger the insertion of a new row?
If you would like help, please answer the questions asked and provide the needed details.
 
Upvote 0

Forum statistics

Threads
1,214,649
Messages
6,120,733
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top