Thanks....I so totally didn't notice that.

"Tom Ogilvy" wrote:

The CHANGE event requires a change in the cell. The suggestion was to use
the SELECTIONCHANGE event which does what you want.

--
Regards,
Tom Ogilvy

"Jimbola" wrote in message
...
This is close but it relies on a change being made to the
cell for it to work. I want the row to be highlighted if
you select it using the mouse or cursor keys

-----Original Message-----
If I read you correctly, you want to select the row for
the cell being made active if that cell is in Column I.

Try this:

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Column = 9 Then
Rows(Target.Row).Select
End If
End Sub

tod
-----Original Message-----
Hi,

I want an entire row to be highlighted (aka selected, as
if clicking on the row number) if I click any cell in
column I. I Know how to select a cell and how to
highlight
a row and how to use the worksheet change event. But not
how to say highlight the row with the cell row number.

Any help would be greatly appreciated.
.

.