PDA

View Full Version : insert 3 blank row if find a string data on column A



parscon
03-26-2013, 10:57 AM
I need a VBA code that can insert 3 blank row before the row have a string in their Column A,


For example

A1 : Boy
A2 : 1234 BOY
A3 : 1234

When run the VBA it will be :

A1:
A2:
A3:
A4:Boy
A5:1234 BOY
A6:1234

and have a loop for others .


Thank you very much

sassora
03-26-2013, 11:43 AM
How about editing this: http://www.vbaexpress.com/forum/showthread.php?t=45746

parscon
03-26-2013, 11:45 AM
Ok it is good but how can I do this ?

Thank you for your help .

sassora
03-26-2013, 12:21 PM
Record macro and then insert lines as normal, stop macro. This will place the insert line code into a new module. Paste the results on the forum.

This is a good way of getting to know what you need to write.

parscon
03-26-2013, 12:29 PM
Thank you very much , if is it possible for you please help me on this subject , I need it .

Thank you .

sassora
03-26-2013, 02:16 PM
http://www.dummies.com/how-to/content/how-to-record-a-macro-to-automate-tasks-in-excel-2.html