Reading Data Rows
Reading Data Rows
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Reading Data Rows

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I view data over 3 Screens (wide). What I want to be able to do is highlight the whole row I am currently on so I can refer to data in different columns. IE I am in cell AA9 and I want to easily see what data is in cell D9. I have used alternate row highlighting, but it would be nicer if when I moved up and down the rows the current row was highlighted and previous row I was on de-highlighted.



  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi UK_Excel

    Right click on the sheet name tab and select "View Code" then paste in this.


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Row > 1 Then
    Target.Offset(-1, 0).EntireRow.Interior.ColorIndex = xlNone
    Target.EntireRow.Interior.ColorIndex = 6
    End If
    End Sub

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks Dave. That's Perfect. I modified the code slightly to include moving up as well as down.

    Target.Offset(1, 0).EntireRow.Interior.ColorIndex = xlNone

    Thanks Again

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com