excel course tate modern - Macro To Change Column

The UK's most regular instructor-led training courses.
Training information: excel course tate modern · Excel advanced · VBA training UK

Resolved · Low Priority · Version Standard

Macro To Change Column

Mekanto has attended:
No courses

by - delegate Mekanto [1 post] (2007 Nov 25 Sun, 15:50) Reply

I need a macro the change the column selected with a cell reference. For example C3 to E3, Without changing the row.

For some reason macro's will not record when I press the arrow keys.
Thanks,
Mekanto

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Macro To Change Column

by - trainer Carlos gold contributer [439 posts] (2007 Nov 26 Mon, 10:16) Reply

Hi Mekanto

The macro recorder only records the arrow movement if the Relative Reference button on the [Stop Recording 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