Creating a macro (vba code) to move every other row

I'm sure this is quite easy, but I am brand new to visual basic language.

What I would like to do is turn this:

1 2 3 4
5 6 7 8
9 10 11 12
13 14 15 16

Into this:

1 2 3 4 5 6 7 8
9 10 11 12 13 14 15 16

In other words, I'd like to move every other row, starting with the second, next to the first and have that repeat down the entire sheet.

Thank you for your help. If my description is too crude please let me know.

This works for your example.

Please Login or Register  to view this content.