How do I change a Macro to use relative cell addresses?
 

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.

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.