Each step in this visual reference is displayed with callouts so you can see exactly where the action takes place on the screen. It covers over 120 tasks, including complete coverage of macros -- with info about VBA basic techniques, variables and arrays, control statements, interfacing with other macros, debugging, add-ins, and automation. The associated website includes tons of usable code and sample macros that readers can put to use instantly.Using simple, straight-forward examples this book demonstrates how to create dynamic programs in Excel 2007.