Look for specific text string, insert row below, insert text to that row

Hello everyone,

I need to modify some very large router configurations for 20+ routers and need to look for a string, for examples sake: String: primary "igp", does the next row contain the text adaptive? no, insert a row below it, and add the word, adaptive, if it does contain adaptive, move on. The reason for needing to search for the text strings is that some of the data will already contain the word adaptive and doesn't need to change, and the row count between the text may change if additional commands are on that configuration. Meaning I can't do a "count 10 rows, insert row, insert text" type macro, it has to look for the text strings.

Book2.xlsm

Maybe:

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

This uses the .Find method

Please Login or Register  to view this content.

AlphaFrog,

This is very close, but when I run the code it finds primary "igp" and inserts blank row, but doesn't put the word adaptive, it does however leave the rows alone that already have adaptive. Can you have a second look?

Perfect my friend! Worked just as intended on my test data. I will do some testing with it to make sure I can't break it, lol one must be very careful running a production routers config through Excel