I am working on a project in which I face a problem that I want to share. Hope someone understands and helps me to solve the problem.
If I select any cell of F9 to I1200 then the target row data from P to U will be shown in P3 to U3. I have the below code but not show the expected result.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target.Column >= 6 And Target.Column < 10 Then If Target = vbNullString Then Exit Sub Else Sheets("Bill Info").[D15] = Cells(Target.Row, 9) Sheets("Bill Info").[A10:A15] = ActiveCell.Row Sheets("Bill").[P3:U3] = Application.Max(Range("P" & Target.Row).Resize(, 6)) End If End If End Sub
Thanks in Advance