Jump to content

Una macro o funcion para indicar la fecha en que se ingreso un dato


Recommended Posts

Hola:

Añade esta macro en la hoja:



Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Column = 9 Or Target.Column = 10) And Target.Row > 4 Then
Range("L" & Target.Row) = Format(Date, "dd/mm/yyyy")
End If
End Sub


[/CODE]

Saludos.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

Privacy Policy