Visual Basic Search Text and Insert Row

Hello,
I need to write a Visual Basic program that will search the Excel sheet for a number and then insert a row where that number occurs. I can write the code to search. I can also write code to insert a row at a specific location. My trouble is with inserting a row that is not known until the search function finds the correct cell.

Thanks for any suggestions!