Highlight some of the cells in a row

I have a worksheet that covers columns (for example) b to f

I want a row to be highlighted when ever I select a cell in that row.

I currently us

Code:

---

.EntireRow.Interior.ColorIndex = 8

---

but that selected all the row (!).... but I only want b to f

Ant suggestions how I do it ?

Try:-

Code:

---

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells(Target.Row, "B").Resize(, 5).Interior.ColorIndex = 8
End Sub

---

Hi Mick ... works perfectly ... many thanks

Andrew

You're welcome