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?
Tue 25 Sep 2007, 10:41Trainer Anthony said...
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
