Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel course tate modern - Macro To Change Column
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel course tate modern - Macro To Change Column
Resolved · Low Priority · Version Standard
Reply
Macro To Change Column
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
For upcoming training course dates see: Pricing & availability
RE: Macro To Change Column
Hi MekantoThe 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
|
 |
|
» Forum post: Master slide |
In the master slide is it possible to set a colour scheme, so that any charts, graphs, tables made in powerpoint are my colours, rather than the maroon etc that powerpoint favours?
