How to insert row above specific text

Hello I am trying to craft a macro in Excel 2010 that will search my 1 sheet worksheet and insert a row above the text I specify.

For example I have a field mobile:***-***-****, I found code that will insert rows every time "mobile" appears, but it won't work for me because mobile will always have different numbers attached to it. So in a sense I need a code that will look for mobile + wildcards and then insert a row above it that will say "replace: mobile"

Here is the current code I found from a previous thread on here:

Please Login or Register  to view this content.

This works great to create a row BELOW "mobile", but I need it to make a row above mobile + wildcards.

Any help would be greatly appreciated!!

Maybe:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

That worked for finding *mobile* and then creating a blank row above it, but it never stopped creating rows.

Generally speaking, avoid using Do/While and instead use for next. It is also accurate to insert from bottom up.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Originally Posted by AB33

Generally speaking, avoid using Do/While and instead use for next. It is also accurate to insert from bottom up.

Please Login or Register  to view this content.

This created a blank row 2 spaces above where "mobile" appeared. Your first code:

Please Login or Register  to view this content.

worked great, if I could just get it to create a line above "mobile" and be able to specify what that line says without it looping forever.

Please Login or Register  to view this content.

This works, but it creates the row below "mobile", if I can just get it to create it above mobile without breaking id be all set.

Change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

Originally Posted by KazigluBey

Please Login or Register  to view this content.

This works, but it creates the row below "mobile", if I can just get it to create it above mobile without breaking id be all set.

As stated earlier by AB33 it is better code from the bottom up, but if you are hooked on the code you originally provided
just change the plus's to minus's

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Originally Posted by JOHN H. DAVIS

As stated earlier by AB33 it is better code from the bottom up, but if you are hooked on the code you originally provided
just change the plus's to minus's

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I am not impartial to any code, just this one seemed easiest to fix. I tried the - instead of + and it just loops until crash.

Please attach a sample so that we can easily see what is going.

Originally Posted by AB33

Please attach a sample so that we can easily see what is going.

Ok with this code:

Please Login or Register  to view this content.

I get this: first macro.JPG

With this code:

Please Login or Register  to view this content.

I get this: macro test 2.JPG

If I replace + with - it puts row above "mobile" but loops till crash.

Can you attach a sample xl file with data so we can test?

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Macro test.xlsx

Originally Posted by JOHN H. DAVIS

Can you attach a sample xl file with data so we can test?

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Yes of course.

Please Login or Register  to view this content.

Originally Posted by AB33

Please Login or Register  to view this content.

This works great so far, any idea what the syntax would be to have it type "replace: mobile" in the blank line it creates?

Kazi,
Please do not reply with quote. Just a reply will do.

Which row are you referring on the attached?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I can use both of your codes as separate macros and get it do exactly what I want. I won't trouble you anymore with combining them. Thank you so much for all of your help!

Try the attached.

That'll do it. Thank you!

You should also thank you John for his equally contribution to the thread.
Could you please now close (Mark) this thread as solved? Go to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.

Yes of course. I submitted reputation to both of you for saving me hours and hours of work! Thank you both!