Macro - Insert given text in-between rows

[L_Checkley]

Hi All,
I have a macro below that allows me to insert a selected amount of rows in between each row.

Please Login or Register  to view this content.

Is there a way to edit this so that it inserts a given text between each row instead of a blank one?

EG,
I have these 4 rows

012266007074431
012342002376343
012682003340172
013036003751731


As it stands it turns out like this

012266007074431

012342002376343

012682003340172

013036003751731


but i need it to turn out like this

012266007074431
*Text*
012342002376343
*Text*
012682003340172
*Text*
013036003751731
*Text*


Ideally I would like to be able to insert anything where *Text* appears

Help would be greatly appreciated

[L_Checkley]

Also,
Ideally im looking to replace the "j = InputBox("type the number of rows to be inserted")" line, as this is now redundant.

[arlu1201]

I_Checkley,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Also,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.