Question: What I am trying to do is when I insert something into column `A` or `B` current date and time to be inserted/updated into column `D`. Of course I already done that but I want to exclude columns `C` and `D` which means when something is inserted in these columns date/time should not be inserted/updated.

```
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Row > 1 Then Cells(Target.Row, "D") = Now()
End Sub

```

Also I have another code but still cannot find a way to exclude some columns (to make a range of columns which updating date/time should work)

```
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target(1, 1).Row > 1 Then
        With Cells(Target(1, 1).Row, "D")
            .Value = Now
            .NumberFormat = "dd-mm-yyyy, hh:mm:ss"
        End With
    End If
End Sub

```

**EDIT: This is my final code.**

```
Private Sub Worksheet_Change(ByVal Target As Range)

    If (Target.Row > 1) And (Target.Column = 1) Then
       With Cells(Target.Row, "D")
            .Value = Date
            .NumberFormat = "dd-mm-yyyy"
      End With
    End If

    If (Target.Row > 1) And (Target.Column = 2) Then
      With Cells(Target.Row, "E")
            .Value = Now
            .NumberFormat = "dd-mm-yyyy, hh:mm:ss"
      End With
    End If

End Sub

```

Answer: 
Updating BIOS from 1.80 to 3.21 **didn't** help.

Those two SATA ports are controlled by ASMedia ASM1061.

I don't know if this controller is garbage or if *exactly these 2 ports* (controlled by ASM1061) were improperly made. But these 2 SATA ports don't work as they must.
> 
> sometimes detected, sometimes not
> 
> 
> 

that is very NOT likely to be fixed with a bios/efi update. Especially for a SATA disk, which is not new technology.

your problems are likely to be, because the connection is intermittent

* a bad sata cable, with the wiring between the two connectors at each end of the cable, fixable by replacing sata cable, $5.
* bad physical connection of the sata cable at either end due to the plastic connector, also fixable by replacing the sata cable
* likewise for the above two for the power sata power connector to the disk; use a different sata power connector from your power supply.
* bad physical connection caused by the sata connector on the disk, which likely will NOT be fixed by a new sata cable, would require new disk.
* a bad sata connector on the motherboard, which would not be fixed by replacing the sata cable, use a different sata port on the motherboard.

systematically switch things out between sata data cable, sata power cable, different disk, and different sata port on motherboard until you determine the cause. It could also potentially be a bad disk (bad sata contoller on disk) but my experience is something like that doesn't manifest as a frequently intermittent problem, they just stop working altogether and the disk doesn't show up.

there is nothing wrong with ASmedia.