|I got it to work, but had to change the code to:|
rw1 = Application.InputBox("Enter Lower Row number")
rw2 = Application.InputBox("Enter Higher Row number")
As I said in Response #4
If the rows are adjacent then the macro works.
What happened when you tried to swap non adjacent rows, is it would move the lower row up one but do nothing with the upper row.
I think we got Upper & Lower confused....
I was thinking Lower Row meant "lower down the sheet" not Lower Numbered Row. :-)
That's why mine worked for me the way I was working.