Hello, I'm new to this forum and also VBA. But I'm trying to learn. I have searched the web and this forum but have not seen something I can built off on.

This is what I have so far, a macro that was able to find the cell string I wanted. And this is what I wanted done:

1. Select from cell say a10 to j10 along with the row below this one. The kicker is the rows are changing.
But I just need it to highlight only these two rows from column a to column j .

2. Do an insert at a10 to push the rest of the sheet down. Copy the two rows above the two newly created rows and pasted it into the newly created rows.

3. Create a macro to undo steps 1 and 2.

Thanks.