highlight only complete row currently being used.
 

Is there a setting that will highlight a complete row if your cursor is in
that row. I know the row number will be highlighted. Thanks

highlight only complete row currently being used.
 

There are methods using sheetchange events but the easiest method is to use
Chip Pearson's RowLiner add-in.

http://www.cpearson.com/excel/RowLiner.htm

Just a note...........Rowliner won't work on protected sheets.

If your sheet is protected you need event code.


Gord Dibben MS Excel MVP

On Thu, 15 Apr 2010 13:25:01 -0700, 2MShad
wrote:

Is there a setting that will highlight a complete row if your cursor is in
that row. I know the row number will be highlighted. Thanks

highlight only complete row currently being used.
 

As Gord suggests, Chip's RowLiner really zeros you in on a secific cell,
along with the column and the row.

If you should only need to highlight a smaller portion of the row you could
use this little 'diddy to do so. It is adjustable to the width you may
want, what column to start and end highlighting. Other colors OUTSIDE the
designated area, Data, are safe.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Data As Range
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim cells As Range
i = 2
j = 8
k = ActiveCell.Column()
Set Data = Range("B8:K22")

Data.Interior.ColorIndex = xlNone

If ActiveCell.Row < 8 Or ActiveCell.Row 22 Or _
ActiveCell.Column < 2 Or ActiveCell.Column 11 Then
Exit Sub
End If

ActiveCell.Offset(0, -(k - i)). _
Resize(1, 10).Interior.ColorIndex = 35 '26

End Sub

HTH
Regards,
Howard


"2MShad" wrote in message
...
Is there a setting that will highlight a complete row if your cursor is in
that row. I know the row number will be highlighted. Thanks

highlight only complete row currently being used.
 

Besides you may try to use "workbook navigation" Excel addins from below
site. It has row highlight options with undo also works.

http://shahshaileshs.web.officelive.com/Addins.aspx


Regards,
Shailesh Shah
http://shahshaileshs.web.officelive.com/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://shahshaileshs.web.officelive.com/MenuAddins.aspx

Free Exshail Classic Menu for Excel-2007
http://shahshaileshs.web.officelive....ssic_Menu.aspx



"2MShad" wrote in message
...
Is there a setting that will highlight a complete row if your cursor is in
that row. I know the row number will be highlighted. Thanks