have a macro that finds and highlights a number (Using the find and replace function). Now I need to expand it to find and highlight a group of numbers (I can paste them into the macro or VBA code) against the numbers in column A. I know there is a way, possibly using case logic or looping but need some help as I am a novice with VBA. Here's what I have in the macro so far:
Sub ReplaceAndHighlight()
'
' ReplaceAndHighlight Macro
' Macro recorded 8/28/2008 by KrazyKasper
'
'
Application.ReplaceFormat.Interior.ColorIndex = 6
Cells.Replace What:=10862, Replacement:=10862, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=True
End Sub
Bookmarks