Page 219 - Excel Progamming Weekend Crash Course

k540629 ch15.qxd 9/2/03 9:34 AM Page 194

194 Saturday Afternoon

REVIEW
The Excel object model provides you with methods that let you search for and replace data
in a worksheet range.
The Range.Find method enables you to locate the first instance of a target within a
specified range.
A search can be restricted to value cells, formula cells, or cell comments.
After calling Find, use the FindNext and FindPrevious methods to continue the
search.
The Replace method enables you to find and replace data in a range.

QUIZ YOURSELF
1. What type of worksheet cells does the Find method search by default? (See the
“The Find Method” section.)
2. What data does the Find method return to the calling program? (See the “The Find
Method” section.)
3. Does the Replace method match case when performing replacements? (See the
“Replacing Data” section.)
4. True or false: The Replace method’s return value gives the number of replacements
that were made. (See the “Replacing Data” section.)