A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

highlight only complete row currently being used.



 
 
Thread Tools Display Modes
  #1  
Old April 15th, 2010, 09:25 PM posted to microsoft.public.excel.newusers
2MShad
external usenet poster
 
Posts: 6
Default 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
  #2  
Old April 15th, 2010, 11:31 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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


  #3  
Old April 15th, 2010, 11:49 PM posted to microsoft.public.excel.newusers
L. Howard Kittle
external usenet poster
 
Posts: 516
Default 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



  #4  
Old April 16th, 2010, 03:12 PM posted to microsoft.public.excel.newusers
Shailesh Shah[_2_]
external usenet poster
 
Posts: 31
Default 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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.