Microsoft Excel 2019 VBA and Macros

Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information, so you can act on it... capture data from anywhere, and use it anywhere... automate Excel 2019's best new features. You'll find simple, step-by-step instructions, real-world case studies, and workbooks packed with bonus examples, macros, and solutions--straight fro.

Title from content provider.

Intro -- Title Page -- Copyright Page -- Dedication Page -- Contents at a Glance -- Contents -- Acknowledgments -- About the Authors -- Introduction -- Chapter 1 Unleashing the power of Excel with VBA -- Barriers to entry -- Knowing your tools: The Developer tab -- Understanding which file types allow macros -- Macro security -- Overview of recording, storing, and running a macro -- Running a macro -- Understanding the VB Editor -- Understanding shortcomings of the macro recorder -- Next steps -- Chapter 2 This sounds like BASIC, so why doesn't it look familiar?

Understanding the parts of VBA "speech" -- VBA is not really hard -- Examining recorded macro code: Using the VB Editor and Help -- Using debugging tools to figure out recorded code -- Object Browser: The ultimate reference -- Seven tips for cleaning up recorded code -- Next steps -- Chapter 3 Referring to ranges -- The Range object -- Referencing ranges in other sheets -- Referencing a range relative to another range -- Using the Cells property to select a range -- Using the Offset property to refer to a range -- Using the Resize property to change the size of a range

Using the Columns and Rows properties to specify a r…