Databases Reference
In-Depth Information
FIGURE 3.14
The extract example final Worksheet.
3.10
SUMMARY
In this section the reader is taught how to manipulate information within the Worksheet environment
through the proper use of variables. The reader is shown how to acquire information about Work-
sheets utilizing VBA code to answer questions such as (1) is a particular Worksheet hidden or
visible? (2) how many Worksheets within a particular Workbook contain data? and (3) how many
rows or columns of data does a Worksheet, or row, or column within a Worksheet contain?
The proper scope and use of variables are covered along with special variable typing such as
static variables, object variables, and arrays. The use of functions is touched on in this chapter but
will be covered in depth in Chapter 4. The differentiation between passing parameters by value or
by reference is explained along with the possible ramifications of being ignorant as to what the
difference is. The use of object variables is covered, which allows the reader to make changes on
entire collections of objects by means of looping structures as opposed to coding all changes
individually. Looping structures are also covered as they relate to populating arrays and other
variables with Worksheet data, or their use in searching for particular discrete pieces of information
within a Worksheet. The utilization of landmarks to locate information within data files is also
explained. The generation of custom reports is touched on in this chapter, but this topic will be
