A Microsoft Excel forum. ExcelBanter

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 » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Highlight entire rows as I scroll?



 
 
Thread Tools Display Modes
  #1  
Old May 20th 05, 03:40 PM
blackrb1
external usenet poster
 
Posts: n/a
Default Highlight entire rows as I scroll?

As I scroll down the rows in Excel, the row number and the current cell are
highlighted. Is there a way to have the entire row be highlighted as I
scroll?
Ads
  #2  
Old May 20th 05, 03:56 PM
external usenet poster
 
Posts: n/a
Default

Hi
Have a look here for an option:
http://www.cpearson.com/excel/RowLiner.htm

--
Andy.


"blackrb1" > wrote in message
...
> As I scroll down the rows in Excel, the row number and the current cell
> are
> highlighted. Is there a way to have the entire row be highlighted as I
> scroll?



  #3  
Old May 20th 05, 04:13 PM
L. Howard Kittle
external usenet poster
 
Posts: n/a
Default

Something like this will high light the row of any cell selected in the
range B8 to K22 from column B to K. You can change to meet your parameters.

Copy and paste into the sheet module. I don't remember if I wrote this or
picked it from the newsgroup, apologies to the author if not mine for not
crediting him/her.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Data As Range
Dim i As Integer
Dim j As Integer
Dim k As Integer
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

End Sub


And one from J. E. that does the whole row and preserves any other color
formatting on the sheet.

' J.E. McGimpsey 6/15/2001
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Static oldRange As Range
Static colorIndices(256) As Integer
Dim i As Integer

If Not oldRange Is Nothing Then 'Restore color indices
For i = 1 To 256
Cells(oldRange.row, i).Interior.ColorIndex = colorIndices(i)
Next i
End If
For i = 1 To UBound(colorIndices)
colorIndices(i) = Cells(ActiveCell.row, i).Interior.ColorIndex
Next i
ActiveCell.EntireRow.Interior.ColorIndex = 15
Set oldRange = ActiveCell.EntireRow
End Sub

HTH
Regards,
Howard

"blackrb1" > wrote in message
...
> As I scroll down the rows in Excel, the row number and the current cell
> are
> highlighted. Is there a way to have the entire row be highlighted as I
> scroll?



 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Isolate rows based on highlight (Excel 2003) Alcide Excel Worksheet Functions 2 April 21st 05 05:40 PM
In Excel, can I shade entire rows based on the value of a single . Todd Excel Worksheet Functions 1 March 24th 05 05:52 PM
Help using Conditional Formating of Entire Rows [email protected] Excel Worksheet Functions 4 February 16th 05 04:29 PM
Using PROPER for Columns, rows or ENTIRE spreadsheet Tom Excel Worksheet Functions 3 February 4th 05 03:43 PM
Search should highlight entire row in Excell in red samuel Excel Discussion (Misc queries) 5 December 27th 04 11:49 PM


All times are GMT +1. The time now is 02:53 AM.


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