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.
You could try disabling the "fast boot" option in bios. This function speeds up boot time by leaving some devices uninitialized during boot. 

In my case, I remember it resulted into similar problems - some HDDs could sometimes be detected and other times not.