Dissect and Learn Excel® VBA in 24 Hours: Working with ranges

No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of working programs. And knowing them, you can easily understand the programs written by others and adopt into your programs the ideas and the efficient code that are presented in those programs.

Dissect and Learn Excel VBA in 24 Hours is a series of quick references for intermediate users who are looking for ideas and samples of VBA code to accomplish certain tasks when they are in the process of writing a program. In this series, you will see thousands of tiny working parts of VBA code that are used to accomplish many simple and yet meaningful tasks. To add a new workbook, to auto-fill a range, to sort a table of data, to generate a table of contents for all chart sheets and worksheets in a workbook, to loop through and manipulate a folder of Excel files, to place a control on the Ribbon, to send an email, and to login to an account in the Internet are some examples of these tiny working parts.

Book 2: Working with ranges focuses on commonly used operations related to worksheet ranges. Selecting a range, finding the last nonempty cell in a range, retrieving the properties of a range (such as address and font), changing the format of a range, converting formulas in a range to values, conditionally formatting a range, sorting a range, filtering a range, copying a range, and exporting a range out of Excel are some of the operations.

To understand better a particular concept discussed in the book, simply copy and paste the sample VBA code stated in the book into the Immediate window or into a standard VBA module, and run the code (or step through the code by using the debugger in VBE). The result is either visible in the Immediate window or in an Excel worksheet. To execute a few lines of code that are not placed in a Sub procedure, simply enclose them in a new procedure in a standard VBA module. You can download the VBA code stated in the book from drive.google.com/file/d/0ByKhn-UYAjlQYm9LNTRWNzl4d2M, or search for any updated URL from the Author Page: amazon.com/Liaw-HockSang/e/B01LX701LY.