Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlight Row & Colum upon cell Select (2000)

    Someone asked me this, and I don't know the answer. So, on to the guru's I go. She wants the row and column to be highlighted when she selects a cell. For example, if she is in cell D14, she wants all of column D (up to row 14) to be highlighted, as well as row 14 (from A to D) to be highlighted. So that wherever she is in the spreadsheet, there will be a row and column highlighted to the active cell.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Highlight Row & Colum upon cell Select (2000)

    Check out this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=36752&page=&view= &sb=&o=&vc=1>This Thread</A>, wher e you will find a number of approaches.

    Andrew C

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight Row & Colum upon cell Select (2000)

    Thanks Andrew. That did have some good ideas. I was hoping there was an Option under Tools or something, but I can work with what was posted.

    Thanks!

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlight Row & Colum upon cell Select (2000)

    If I understand your question correctly, the following code in the Workbook SelectionChange event routine in the module behind the workbook object will do it:

    <pre>Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
    Application.EnableEvents = False
    Union(Target.EntireRow, Target.EntireColumn).Select
    Target.Activate
    Application.EnableEvents = True
    End Sub
    </pre>

    Legare Coleman

Posting Permissions

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