98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version 2007
Fri 20 Mar 2009, 16:21Delegate Anthony said...
Anthony has attended:
Excel Intermediate course
Excel Advanced course
Macros
Can a Macro be limited by size?
Thu 26 Mar 2009, 09:55Trainer Stephen said...
RE: Macros
Hi Anthony
Thank you for your question
The short answer is no. A macro is essentially a procedure written in VBA. There is no practical limit to the size of a procedure.
However, it is better to split a problem down into a series of small tasks that need to be carried out in sequence. You then record separate macros for each task and then write a main macro that simply runs each of the smaller macros in turn
This simplifies the recording process and makes the macro easier to maintain
Regards
Stephen
Wed 1 Apr 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:The dual nature of toolbar buttonsMany toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right. |
