that did help, norman, thanks. i almost had it but wasn't quite sure how to
sotre the last range

i adapted chip's code to highlight the entire row in case the op wanted it
that way

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static OldRange As Range
On Error Resume Next
Target.EntireRow.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.EntireRow.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target

End Sub

--


Gary


"Norman Jones" wrote in message
...
Hi Escelinen,

See Chip Pearson's highlighting page at:

http://www.cpearson.com/excel/excelM...ightActiveCell

---
Regards,
Norman



"escelinen" wrote
in message ...

Hello everyone,

I know how to change color for the active cell
(ActiveCell.Interior.Colorindex=15) in Worksheet_SelectionChange Sub,
but how can I change the color for the entire row where active cell is
located? And to be more challenging, I want to change default color
back when active cell is out of highlighted row.


--
escelinen
------------------------------------------------------------------------
escelinen's Profile:
http://www.excelforum.com/member.php...o&userid=27966
View this thread:
http://www.excelforum.com/showthread...hreadid=475704