The names will always be the same 4 people it is just there row that will change. I am just trying to get 1 row moved right now and im still getting same error. I have attached a screenshot of the debug screen. and the code.
[vba]img27.imageshack.us/img27/1730/97992350.png[/vba]