- Cover Page
- 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
- Chapter 2 This sounds like BASIC, so why doesn’t it look familiar?
- 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 range
- Using the Union method to join multiple ranges
- Using the Intersect method to create a new range from overlapping ranges
- Using the IsEmpty function to check whether a cell is empty
- Using the CurrentRegion property to select a data range
- Using the Areas collection to return a noncontiguous range
- Referencing tables
- Next steps
- Chapter 4 Looping and flow control
- Chapter 5 R1C1-style formulas
- Chapter 6 Creating and manipulating names in VBA
- Chapter 7 Event programming
- Chapter 8 Arrays
- Chapter 9 Creating classes and collections
- Chapter 10 Userforms: An introduction
- Chapter 11 Data mining with Advanced Filter
- Replacing a loop with AutoFilter
- Advanced Filter—easier in VBA than in Excel
- Using Advanced Filter to extract a unique list of values
- Using Advanced Filter with criteria ranges
- Using filter in place in Advanced Filter
- The real workhorse: xlFilterCopy with all records rather than unique records only
- Next steps
- Chapter 12 Using VBA to create pivot tables
- Chapter 13 Excel power
- Chapter 14 Sample user-defined functions
- Chapter 15 Creating charts
- Chapter 16 Data visualizations and conditional formatting
- Chapter 17 Dashboarding with sparklines in Excel 2019
- Chapter 18 Reading from and writing to the web
- Chapter 19 Text file processing
- Chapter 20 Automating Word
- Using early binding to reference a Word object
- Using late binding to reference a Word object
- Using the New keyword to reference the Word application
- Using the CreateObject function to create a new instance of an object
- Using the GetObject function to reference an existing instance of Word
- Using constant values
- Understanding Word’s objects
- Controlling form fields in Word
- Next steps
- Chapter 21 Using Access as a back end to enhance multiuser access to data
- Chapter 22 Advanced userform techniques
- Chapter 23 The Windows Application Programming Interface (API)
- Chapter 24 Handling errors
- What happens when an error occurs?
- Basic error handling with the On Error GoTo syntax
- Generic error handlers
- Training your clients
- Errors that won’t show up in debug mode
- Errors while developing versus errors months later
- The ills of protecting code
- More problems with passwords
- Errors caused by different versions
- Next steps
- Chapter 25 Customizing the ribbon to run macros
- Chapter 26 Creating add-ins
- Chapter 27 An introduction to creating Office add-ins
- Chapter 28 What’s new in Excel 2019 and what’s changed
- Index
- Code Snippets
For Chip Pearson. Chip’s website on VBA helped tens of thousands of people around the globe. We were sorry to hear that he died this year in an auto accident and dedicate this edition of the book to Chip.
—Bill Jelen & Tracy Syrstad
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.