Private Sub Worksheet_Change(ByVal Target As Range)
If Range("E3").Value <> "" Then
Rows("3:3").Select
Range("D3").Activate
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("E3").Select
End If
If Target.Column < 6 Then
Cells(Target.Row, 6).Value = Now
End If
End Sub
No hay comentarios:
Publicar un comentario