Dear all,

I have a question and hope someone could help save me from it.

I need to create a macro to find the phrase "I Love You" in an excel worksheet column B.
However, this seleceted phrase always appear in different rows depending on the month.

After the macro helped seaching the phrase "I Love You", i need to insert 7additional rows below it.


In conclusion, is there anyone that knows the macro to search the phrase "I Love You" in column B (but the row that the phrase will be located in differ).
after searching the phrase, the macro would also help adding 7 rows below it.


thank you very much in advance.