Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel consultant - Macros

Resolved · Low Priority · Version Standard

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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

Excel articles

· More Tips From Excel's Rarely Used File
· How To Create A Custom List In Excel
· How To Use Freeze Panes In Excel 2007
· What's Better Than the Help Function in Excel? Microsoft Training
· How Getting Together Is Now Even Easier With Excel

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips