homework?
try recording a macro while doing this manually

--
Don Guillett
SalesAid Software

"Roger D" wrote in message
...
I have a worksheet with data in column A and B. I want to start in cell
a1
and go down, depress the shift key, right arrow, edit, cut, right, right,
up,
return, left, left, down, delete row.

I will then be in cell a2 and I want to do this repeatedly.