Hi Experts,
i am using below code for highlighting current selected cell row & column:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim strRange As String
strRange = Target.Cells.Address & "," & _
Target.Cells.EntireColumn.Address & "," & _
Target.Cells.EntireRow.Address
Range(strRange).Select
End Sub
But it has a problem i cant design any cell or row or column using fill color. when i make a fill color of any cell/row/column its automatically remove. But i wants to keep it. Please help me & also i attached my file.
Bookmarks