Dim target As Range
Dim dc1 As Long
Set target = Range("b4")
With Sheets("histo")
dc1 = .Cells(target.Offset(0, -1) + 3, Rows(target.Offset(0, -1) + 3).Cells.Count).End(xlToLeft).Column + 1
.Cells(target.Offset(0, -1) + 3, dc1) = Format(Now, "dd.m.yyyy")
End With
[B]With Sheets("compte")
.Cells(target.Offset(0, -1) + 3, 3) = "1"[/B]
End With