excel course tate modern - Macro To Change Column

Hi Mekanto

The macro recorder only records the arrow movement if the Relative Reference button on the [Stop Recording[/b] toolbar is clicked.

Once its done if you move from C3 to E3, using the arrow, it will record the following code:

ActiveCell.Offset(0, 2).Range("A1").Select

NB This moves the cursor 2 columns to the right irrespective of the start point

If you require the cursor to always go to E3 then:

1. Record the macro without the Relative Reference button being selected

2. Select E3

The code is recorded as

Range("E3").Select

Hope this helps

Carlos