Working with Find and Replace : Find « Forms « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Forms
  3. Find

Working with Find and Replace

 
Sub cell()
    Cells.Find(What:="2008", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
        :=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        True, SearchFormat:=False).Activate
End Sub








Related examples in the same category

1.Consider only cells that contain data in the form of numbers, text, and formulas
2.Uses the Find method to reduce the number of cycles spent in VBA loops:
3.Continuing a Search with the FindNext Method and FindPrevious Method
4.Searching for and Replacing Formatting
5.Finding the Last Used Cell in a Column or Row
6.Ride the Range from the Bottom to Find Last Row
7.Find the First Non-Zero-Length Cell in a Range