Highlight Row & Colum upon cell Select (2000)

Topic

New Reply

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.

Reply | Quote

Replies

Check out this This Thread, wher e you will find a number of approaches.

Andrew C

Reply | Quote

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!

Reply | Quote

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:

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

Reply | Quote