excel consultant - macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultant - Macros

excel consultant - Macros

resolvedResolved · Low Priority · Version Standard

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips


Server loaded in 0.1 secs.