Control and Manipulation of Worksheet Data
The founding principle upon which this text is based is that it give the reader the tools to construct useful applications. In order to accomplish that task, the user must have the ability to control and manipulate data that reside in any given Worksheet within any given Workbook. For this, the programmer must have the ability to make determinations about what any given Workbook or Worksheet contains, and further, must have the ability to determine where specific pieces of data actually reside within a specific Worksheet. The programmer must also have the ability to copy information to variables where it can be stored, examined, modified, and manipulated. Finally, the developer must also have the ability to create new Workbooks and Worksheets in which to store information that has been analyzed and processed by a macro, most often for reporting purposes. This chapter covers these kinds and types of processes.