Page 212 - Excel Progamming Weekend Crash Course

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

SESSION

15

Find and Replace Operations

Session Checklist

✔ Using the Find method to search for data in a worksheet range
✔ Controlling search details with Find method arguments
✔ Using the FindNext and FindPrevious methods to continue a search
✔ Calling the Replace method to locate and replace data in a range

E xcel and VBA provide tools that enable you to search for data in a worksheet and
optionally replace it with other data. These tools are the topic of this session.

Finding Data
There are three methods that you can use when finding data in a worksheet:

Find. This starts a find operation and locates the first occurrence of the target.
FindNext. This method locates the next occurrence of the target after a find opera-
tion is in progress.
FindPrevious. This method locates the previous occurrence of the target after a
find operation is in progress.

These methods are covered in the following sections.