Your favorite local bookstore.
Everywhere.

Sign up for our mailing list and save! JOIN THE LIST
Dissect and Learn Excel Vba in 24 Hours

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.



  • Condition: --
    HPB condition ratings
    • New: Item is brand new, unused and unmarked, in flawless condition.
    • Fine/Like New (F): No defects, little usage. May show remainder marks. Older books may show minor flaws.
    • Very Good (VG): Shows some signs of wear and is no longer fresh. Attractive. Used textbooks do not come with supplemental materials.
    • Good (G): Average used book with all pages present. Possible loose bindings, highlighting, cocked spine or torn dust jackets. Used textbooks do not come with supplemental materials.
    • Fair (FR): Obviously well-worn, but no text pages missing. May be without endpapers or title page. Markings do not interfere with readability. Used textbooks do not come with supplemental materials.
    • Poor (P): All text is legible but may be soiled and have binding defects. Reading copies and binding copies fall into this category. Used textbooks do not come with supplemental materials.
    Conditions Guide
  • Format: Paperback
  • Sold by: --
  • Language: English
  • Publisher: Createspace Independent Pub
  • ISBN-13: 9781724298409
  • ISBN: 1724298402
  • Publication Year: 2018
HPB pick - Out of stock
Loading...
Loading marketplace...
HPB condition ratings
  • New: Item is brand new, unused and unmarked, in flawless condition.
  • Fine/Like New (F): No defects, little usage. May show remainder marks. Older books may show minor flaws.
  • Very Good (VG): Shows some signs of wear and is no longer fresh. Attractive. Used textbooks do not come with supplemental materials.
  • Good (G): Average used book with all pages present. Possible loose bindings, highlighting, cocked spine or torn dust jackets. Used textbooks do not come with supplemental materials.
  • Fair (FR): Obviously well-worn, but no text pages missing. May be without endpapers or title page. Markings do not interfere with readability. Used textbooks do not come with supplemental materials.
  • Poor (P): All text is legible but may be soiled and have binding defects. Reading copies and binding copies fall into this category. Used textbooks do not come with supplemental materials.
Conditions Guide
HPB condition ratings
  • New: Mint condition or still sealed (SS). Absolutely perfect in every way. New.
  • Fine/Like New (EX): No defects, little sign of use, well cared for. Plays perfectly. Close to new. Not necessarily sealed or unused, but close. Could be an unopened promotional or cut item. Sometimes called: mint-minus.
  • Very Good (VG): Will show some signs that it was played and otherwise handled by a previous owner who took good care of it.
  • Good (G): Attractive and well cared for, but no longer fresh. Minor signs of wear, scuffing or scratching, but will play almost perfectly. For vinyl: barely detectable crackles or pops.
  • Fair (FR): This item is in okay condition. For vinyl: good is not so good and the record may have low level crackles or pops when playing. CD: one or more tracks may skip.
  • Poor (P): Obviously well-worn and handled. Most vinyl collectors will not buy good or below, but some tracks on CD or vinyl will play.
Conditions Guide
HPB condition ratings
  • New: This movie is unopened and brand new.
  • Fine/Like New (EX): Near new. No defects, little sign of use. Plays perfectly. Not necessarily sealed or unused, but close. No skipping; no fuzzy or snowy frames in VHS.
  • Very Good (VG): Attractive and well cared for but no longer fresh. Minor signs of wear, but will play almost perfectly. For VHS: barely detectable distortion or very few fuzzy or snowy frames.
  • Good (G): This item is in okay condition and basically works well. There may be some minor distortion on VHS tape; slight scratching or wear on DVD.
  • Fair (FR): Basically plays, but may be obviously well-worn with some scratching or tape distortion.
  • Poor (P): Disc or tape is intact, but may be scratched or stretched. There may be skips or distortion or product defects.
Conditions Guide
×