financial excel course london - Macro

The UK's most regular instructor-led training courses.
Training information: financial excel course london · Excel training london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Macro

Delia has attended:
Excel Advanced course
Excel VBA course
Excel VBA course

by - delegate Delia [2 posts] (2007 Mar 1 Thu, 09:57) Reply

How do you run a macro?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: macro

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 2 Fri, 10:56) Reply

Once you have created a macro you go into the Tools option and down to Macro>Macros (or you can press Alt F8) then highlight the macro you have created, then click on the run option.

Good luck

Tracy

· How to Create Better Excel Spreadsheets: Part Three
· Benefits of learning about Excel charts
· Tips to Facilitate Printing of Excel worksheets
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips