Hi, to explain what I am trying to achieve is this.
I have several columns and rows of data and I wish to move certain cells
around in the same row.
I have made a macro that moves 2 cells to a blank space, move 2 other cells
into its cells and the moves the first 2 cells in its place

however the macro alway returns to the cell address where I made the macro
I would like it to commit what ever row i am in
Hope u can understand what I am trying to achieve.

1 ONEMORENOMORE 3 DELAGO BOLT
3 GRAHAM 8 WILLIAM
The macro in this case would swap n08 william with 3 Graham
Regards
Graham