Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Isabelle!
I've tried it but without success. I think it's not really jumping to Word to find the text isn't it? I've used the following code: Sub MacroIsab() Dim keywords As String, c As Range, n As Integer keywords = "verliep" ' adapt With Worksheets(1).Range("a1:a500") Set c = .Find(keywords, LookIn:=xlValues, LookAt:=xlPart) If Not c Is Nothing Then firstAddress = c.Address Do n = Application.Find(keywords, c) With c.Characters(Start:=n, Length:=Len(keywords)) .Font.Color = RGB(255, 0, 0) End With Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I search for a word within a excel document | Excel Discussion (Misc queries) | |||
How do I search for a word and add text to a cell if found? | Excel Programming | |||
Print Word document based on Excel dialog selections | Excel Programming | |||
moving text from a word document to excel | New Users to Excel | |||
Macro to copy cell data to word document based on an active row? | Excel Programming |