Move cells under a specific text to right

[veeru612]

Hello Excel Pundits,
I need a small favor.
I have a file like this

string1
1 4 7
2 5 8
3 6 9
string2


I need to write a macro that searches this specific string1 and shift the numbers underneath the cell until string2 to right.

thank you so much for the help.

 

[veeru612]

Never mind, figured out the solution. I just had to use range function to address the cells.