Quick Links ▼

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - How do a repeat this macro command till it reaches the last spre

	98.1 % recommend us
	More live stats...

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

Training information:

microsoft excel training - How do a repeat this macro command till it reaches the last spre

Resolved · Low Priority · Version Standard

Reply Wed 4 Apr 2007, 17:41Delegate Alistair said...

Alistair has attended:
Excel Advanced course

How do a repeat this macro command till it reaches the last spre

How do a repeat this macro command till it reaches the last spreadsheet?

ActiveCell.Cells.Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveSheet.Previous.Select
ActiveCell.Cells.Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveSheet.Previous.Select

Cheers
ALi.

For upcoming training course dates see: Pricing & availability

Reply Wed 18 Apr 2007, 14:24Trainer David said...

RE: How do a repeat this macro command till it reaches the last

Ali

If you attend one of our VBA courses and bring along your example then we should be able to help resolve this issue.

regards

david

Reply Wed 18 Apr 2007, 14:29Delegate Alistair said...

RE: How do a repeat this macro command till it reaches the last

Hi David,

I intend to go on your course... as soon as I get some free time!

Cheers
ALi.

P.S. I have now finished the project that related to the query. I ended up using a work-around.

Excel articles

· Excel Charts As Easy As Pie
· Backstage Management With Excel 2010
· Microsoft Excel provides the building blocks of shared information
· Interesting Lifestyle Applications for Microsoft Excel
· Make Things Easier In Excel With Lists

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips