Auto copy and paste to value

[gmduece]

Hello

I have a time stamp formula, =IF(A5>0,NOW(),""), to set the time of an entry into A5. How can I auto copy and paste value as a continuation of my formula?

Thank You

 

[Dad_x6]

I understand that you are automatically populating this cell with a time stamp if A5 gets populated, but what do you mean auto copy and paste value? Did you want to paste the timestamp, or the formula to add the timestamp?

 

[gmduece]

Negative,
the NOW() function is fluid and will change each second to current time unless I copy it and the paste VALUE rather than FORMULA

Thank You

 

[Dad_x6]

So... Are you looking for something like this?

Selection.PasteSpecial Paste:=xlPasteValues