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
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