Microsoft Office Tutorials and References
In Depth Information
19.3.25 Find Method
The FillDown method fills down from the top cell or cells in the specified range to the bottom of
the range. The contents, formulas, and formatting of the cell or cells in the top row of a range are
copied into the rest of the rows in the range. The syntax is:
RangeObject .FillDown
For instance, the code:
Range("B3:D5").FillDown
will duplicate the values of cells B3 through B5 in cells C3 through C5 and D3 through D5.
19.3.25 Find Method
The Find method returns the first cell in a given range that satisfies a criterion. Note that the Find
method returns Nothing if no match is found. In any case, it does not affect the selection or the
active cell.
The syntax of the Find method is:
RangeObject .Find( What , After , LookIn , LookAt , _
SearchOrder , SearchDirection , MatchCase , MatchByte )
Note that all of the parameters except What are optional.
The What parameter is the data to search for and can be a string or any other valid Excel data type
(number, date, etc.).
The After parameter is the cell after which the search should begin. (This would be the active
cell when doing a search from the user interface.) Thus, the cell referred to by After is the last
cell searched. If the After argument is omitted, the search starts after the cell in the upper-left
corner of the range.
The LookIn parameter is one of the following constants:
Enum XlFindLookIn
xlValues = -4163
xlComments = -4144
xlFormulas = -4123
End Enum
The LookAt parameter is one of the following constants that determines whether the What value
must match the cell's entire contents or just any part of the cell's contents:
Enum XlLookAt
xlWhole = 1
xlPart = 2
End Enum
The SearchOrder parameter is one of the following XlSearchOrder constants:
Enum XlSearchOrder
xlByRows = 1
xlByColumns = 2
End Enum
Search JabSto ::




Custom Search