Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Loop or Next
I am a new to Excel VBA and trying write a macro for find a specific word in
a range. If the specific word is found change the colour. My problem is how to get a loop going ?? here is my code PLEASE HELP Sub colour() Application.ScreenUpdating = False Range("A:A").Select Selection.find(What:="summary", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False).Activate ActiveCell.Select ActiveCell.Font.Bold = True ActiveCell.Font.ColorIndex = 3 Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with using a Macro Loop | Excel Discussion (Misc queries) | |||
Loop to run macro each row | Excel Discussion (Misc queries) | |||
how to put a loop in a macro? | New Users to Excel | |||
Loop Macro? | Excel Programming |