i have a macro to run which copies the =now() from another cell same page
this is the code
the problem is the copied date is changed and wrong example the month and day swap around
how can I ensure when the macro runs the correct dd/mm/yyyy hh:mm is pasted
this is the code
Code:
Sub Macro11()
'
' Macro11 Macro
'
'ActiveSheet.Unprotect "6477"
Range("m2").Select
Selection.Copy
Range("B" & Rows.Count).End(xlUp).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("c" & Rows.Count).End(xlUp).Offset(1).Select
ActiveCell.FormulaR1C1 = "IN"
Range("d" & Rows.Count).End(xlUp).Offset(1).Select
'ActiveSheet.Protect "6477"
End Sub
the problem is the copied date is changed and wrong example the month and day swap around
how can I ensure when the macro runs the correct dd/mm/yyyy hh:mm is pasted
Last edited by a moderator: