greeknax.blogg.se

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