VBA methods and properties for data visualizations While building a pivot table in Excel VBAĬhapter 16 Data visualizations and conditional formatting Understanding how pivot tables evolved over various Excel versions The real workhorse: xlFilterCopy with all records rather than unique records onlyĬhapter 12 Using VBA to create pivot tables Using Advanced Filter with criteria ranges Using Advanced Filter to extract a unique list of values Using user-defined types to create custom propertiesĬhapter 11 Data mining with Advanced FilterĪdvanced Filter-easier in VBA than in Excel Trapping application and embedded chart events Using the Areas collection to return a noncontiguous rangeįlow control: Using If.Then.Else and Select CaseĬhapter 6 Creating and manipulating names in VBAĬhapter 9 Creating classes and collections Using the CurrentRegion property to select a data range Using the IsEmpty function to check whether a cell is empty Using the Intersect method to create a new range from overlapping ranges Using the Union method to join multiple ranges Using the Columns and Rows properties to specify a range Using the Resize property to change the size of a range Using the Offset property to refer to a range Using the Cells property to select a range Referencing a range relative to another range
Using debugging tools to figure out recorded code Understanding shortcomings of the macro recorderĬhapter 2 This sounds like BASIC, so why doesn’t it look familiar?Įxamining recorded macro code: Using the VB Editor and Help Overview of recording, storing, and running a macro
Understanding which file types allow macros Chapter 1 Unleashing the power of Excel with VBA