- 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
Microsoft Excel 2019 VBA and Macros
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.