Macros

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

Resolved · Low Priority · Version Standard

Macros

Pam has attended:
Powerpoint Introduction course
Excel Advanced course

by - delegate Pam [1 post] (2008 Feb 8 Fri, 17:13) Reply

How many actions can I store in one macro?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Macros

by - trainer Stephen gold contributer [394 posts] (2008 Feb 10 Sun, 13:29) Reply

Hello Pam

Thank you for your question

In principle you can store as many actions as you wish in a macro.

I practice however it is better to create a series of smaller, discrete macros each carrying out a specific task, and then set them to run concurrently.

This makes them easier to record/write and to debug when they go wrong

Regards

Stephen

· How to Create Better Excel Spreadsheets: Part Three
· Crazy Things People Have Done With Excel
· Excel and Inventory Management
· Interesting Lifestyle Applications for Microsoft Excel
· Database Tips from an Excel Training Course

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

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips

Rate this page: