Let me however add one more layer of complexity. Here's the challenge: I have information in rows 12-15 of my spreadsheet. A userform opens and a listbox is populated with the values of B12:B15. Two command buttons allows the user to move items in the listbox up or down. When the user clicks okay, I then want the corresponding rows to change orders. Does that make sense?
So, i'm thinking of testing for the value in B12:B16 and assigning it to a variable, at which point I should be able to use the code you wrote. Thoughts???