View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Art
 
Posts: n/a
Default which line mercy script

nastech,

I don't know if there's a formula. However, you could put the following
macro in the Sheet you're working with:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static mRow As Long
If mRow < 0 Then
Rows(mRow).Interior.ColorIndex = xlNone
End If
mRow = Target.Row
Rows(mRow).Interior.ColorIndex = 56
End Sub

You would get there by hitting the visual basic editor and looking for the
sheet name. Double click on it to get a blank screen and paste the macro in
there. It should work.

"nastech" wrote:

Going Blind... is there a code for hiliting a row when any cell in that line
is selected. Thanks.............