Macros

The UK's most regular instructor-led training courses.
Training information: excel computer 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

Macros

Laura has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Laura [3 posts] (2008 Feb 13 Wed, 17:19) Reply

how do you record 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: macros

by - trainer Carlos gold contributer [394 posts] (2008 Feb 22 Fri, 15:59) Reply

Hi Laura

To record a macro do the following:

1. Open the Tools menu, select Macro and then click Record New Macro.

2. In the Record Macro dialog box, type a name for the macro in the Macro name box.

NB Macro names must start with a letter and can include letters, numbers, and underscore characters, but can't include spaces. You don't need to change the other boxes.

3. When you click OK, the Stop Recording toolbar appears, and you're ready to record. Until you stop the recording, every Excel command and keystroke will be recorded in the macro, in the order in which they are entered.

4. To finish recording the macro, click the Stop Recording button.

Hope this helps

Carlos

· Microsoft Excel Features and Functions for Accountants
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Customized Financial Excel Courses in London
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips