Highlight row
 

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.

Highlight row
 

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.
.

Highlight row
 

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.
.

.

Highlight row
 

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.
.

.

Highlight row
 

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.
.

.