| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a macro to use relative cell addresses? | Excel Discussion (Misc queries) | |||
| macro help | Excel Discussion (Misc queries) | |||
| Relative Cell position NOT working with or without macro | Excel Discussion (Misc queries) | |||
| Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Linear Mode
