98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Macros
excel consultant - Macros
Resolved · Low Priority · Version Standard
Fri 5 Oct 2007, 16:41Delegate Tim said...
Tim has attended:
Excel Advanced course
Macros
How do i write a macro to move a range of cells 1 cell to the right. The challenge is that I want to change the range each time I run the macro, so each week I want to move a selection of cells one cell to the right to reflect the latest 4 week average
Wed 17 Oct 2007, 09:13Trainer Carlos said...
RE: Macros
Hi Tim
If the range of cells you want to move right is in a column that does not interfere with other data the simplest thing to do is create a macro to:
Select a cell in the current data range
Insert a new column. The code is:
Selection.EntireColumn.Insert
Enter a heading for the new data
Hope this helps
Carlos
Training information:
See also:
|
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 tip:Formst Excel to display leading zeroesSelect the cells that you want to have displaying leading zeroes. |
