Databases Reference
In-Depth Information
subroutine. Notice that this function makes use of the previously defined
ColNoToColLet
function earlier in this chapter.
Function GetColRng(ByVal startcol As Integer, ByVal endcol As
Integer) As String
GetColRng =
ColNoToColLet
(startcol)
& ":" &
ColNoToColLet
(endcol)
End Function
1.10
DELETING ROWS AND COLUMNS
Invariably, when working with copious amounts of data, there will be data that are to be retained
and data that are to be eliminated. The most convenient way of eliminating unwanted data is to
delete the row or column it reside in. This works quite well if each row or column holds values
related to a single specific parameter. Should a column or row hold values for multiple parameters,
this approach is not practical. In such instances, data must be removed on a cell-by-cell basis.
Often, in a Worksheet that contains a report, each row will hold values pertaining to a specific
parameter. An example report to be utilized for purposes of this discussion is shown in Figure 1.12.
In the report in Figure 1.12, a number of compounds have been analyzed by a machine. Each
row contains data related to a single compound, where compounds are identified by the “CMPD-
prefix. Suppose in this report there are standards that are run to check the integrity of the testing
being done. In this case, the standards are chloramphenicol, nifuroxime, and bromoquinoline. At
the end of the analysis it is desired to automatically remove the rows that contain the standards
FIGURE 1.12
An example report.
