ahhhhhh what am i doing

[bongobus]

not sure what I'm doing wrong

I set a macro to run which copies a date time from a cell which is =now() ----- and pastes its value to another cell

the result was not the correct time lol keeps returning time 19:48

 

[bongobus]

not sure what I'm doing wrong

I set a macro to run which copies a date time from a cell which is =now() ----- and pastes its value to another cell

the result was not the correct time lol keeps returning time 19:48

code

Range("B1").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

 

[shg]

How about instead

  Cells(Rows.Count, "B").End(xlUp)(2).Value = Now()

 

[bongobus]

Was my error - didn’t notice row 1 hidden lol now ok