Highlight row and column

My Aswer Is This said:

You want the interior color of the column and row filled with some color? What color?
That could be a problem filling millions of cells with an interior color.

Click to expand...

My Aswer Is This said:

Try This:
Double click on the cell you want highlighted and this script will run
To install this code:

Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the below code in the VBA edit window

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Cells.Count > 1 Then Exit Sub
Rows(Target.Row).Interior.ColorIndex = 4
Columns(Target.Column).Interior.ColorIndex = 4
End Sub

Click to expand...

My Aswer Is This said:

Try This:
Double click on the cell you want highlighted and this script will run
To install this code:

Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the below code in the VBA edit window

Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Cells.Count > 1 Then Exit Sub
Rows(Target.Row).Interior.ColorIndex = 4
Columns(Target.Column).Interior.ColorIndex = 4
End Sub

Click to expand...

Peter_SSs said:

Did you try that code (a few times)? You could quickly become lost again.

Click to expand...

My Aswer Is This said:

Peter.I asked first and gave him what he wants.

Click to expand...