Add Blank rows & text

[anbusds]

Hi all,
please let me know how to insert 5 blank rows after grouping & add some text after insert at the blank rows in excel?

Ex: i have 10 rows
A
A
B
....
i want to insert 5 blank rows(Add some text after insert) after Group A

is it possible?
Thanks in advance!!!

 

[Ranman256]

In excel, l write a macro.
To do this, click Record, perform the actions, stop recording.
Then modify the macro to do what you need.

 

[anbusds]

Hi,
Thanks for your reply...

I use Button to perform this action...
can i have the VBA code to do this?

 

[Grumm]

Do you need a macro or a Button with a form ?
Is it hard coded that you must insert x lines after group A ?

I guess you need a form to enter the number of lines that needs to be inserted. And after what group.