![]() |
#1
|
|||
|
|||
![]()
below code is for one word monkey
in this only i want to search more words how? Sub example() Dim iLoop As Integer Dim i As Integer Dim rNa As Range ' count number of monkeys in Activesheet (change to sheet required) iLoop = WorksheetFunction.CountIf(ActiveSheet.UsedRange, "*" & "monkey" & "*") ' loop through and find monkeys Set rNa = ActiveSheet.Range("A1") ' change sheet if necessary For i = 1 To iLoop Set rNa = Cells.Find(What:="monkey", After:=rNa, _ LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) ' highlight the rows rNa.EntireRow.Interior.ColorIndex = 36 Next i End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
SDondeti | Word VBA | 4 | 08-15-2012 05:03 PM |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
find&replace word in uppercase with word in lowercase | andrei | Word | 3 | 10-03-2011 05:11 AM |
![]() |
Jamal NUMAN | Word | 2 | 06-26-2011 09:49 AM |
How to find out the version of the word files? | mariaprabudass | Word | 0 | 06-18-2010 05:40 AM |