Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Recording Macros
|
|
|
The UK's most regular 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 courses - Recording Macros
Resolved · Low Priority · Version Standard
Reply Fri 14 Sep 2007, 16:28Delegate Atia said...
Atia has attended:
Excel Intermediate course
Recording Macros
Is there a limit to how complex a macro can be ie can you record construction of pivot tables and the subsequent formatting of these pivot tables?
For upcoming training course dates see: Pricing & availability
RE: Recording Macros
Hi Atia. Essentially, macros can be as complicated as you want them to be. The trick is to make the VBA code as "clean" and elegant as possible. You certainly can use macros to generate and reformat pivot tables, although ideally you need to do this within the Excel VBA environment itself as otherwise it can be extremely difficult just using the Macro recorder.
Hope this helps,
Anthony
|