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