Hello All

I have a macro that I recorded and it works OK - except that when I used the
up/down/left/right arrows during the recording, this didn't seem to be
included in the macro. The actual cell addresses were recorded, whereas I
wanted to say "now move down 5 cells".
Is there a way of getting the macro to include these commands - or
alternatively of editing the macro and adding them directly?

Thanks for any help
Les

You can "move down" using something like

ActiveCell.Offset(5, 0).Activate

However, using selections are usually rather difficult to maintain.
Perhaps if you posted the relevant code, some suggestions could be
made...


In article ,
"Leslie Isaacs" wrote:

Hello All

I have a macro that I recorded and it works OK - except that when I used the
up/down/left/right arrows during the recording, this didn't seem to be
included in the macro. The actual cell addresses were recorded, whereas I
wanted to say "now move down 5 cells".
Is there a way of getting the macro to include these commands - or
alternatively of editing the macro and adding them directly?

Thanks for any help
Les