I need to be able to find either a word or a word that starts with xx and then highlight a specific range.
I have this code but it only highlights the word. Could someone assist please. I need to be able to Highlight the row from A to R
Dim vCells As Range
For Each vCells In Range("A1:A2000").Cells
If Left(vCells.Text, 2) = "Ev" Then
vCells.Interior.ColorIndex = 43
vCells.Borders.LineStyle = xlContinuous
vCells.Borders.Weight = xlThin