excel courses - Recording Macros

Resolved · Low Priority · Version Standard

Recording Macros

Atia has attended:
Excel Intermediate course

by - delegate Atia [1 post] (2007 Sep 14 Fri, 16:28) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Recording Macros

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 10:41) Reply

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

· Microsoft Excel Training - Numerical excellence for all
· Database Tips from an Excel Training Course
· Compare Different MS Excel Training Methods
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How to Create Better Excel Spreadsheets: Part One

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Rate this page: