Resolved Question: Excel - VBA to highlight cell when column is selected?
Answers really appreciated!
I have this code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("C:C").Interior.ColorIndex = xlNone
Cells(ActiveCell.Row, "c").Interior.ColorIndex = 37
End Sub
Whenever a row is selected, this highlights the cell in column C that appears in that row.
How can I adapt this so that whenever a column is selected, the corresponding cell in row 2 is highlighted?
Eg I select a cell in column B, cell B2 is highlighted
Or I select a cell in column C, cell C2 is selected
And so on...
