Copy and Paste Cell automatically every 20 mins

Hi zit1343,

This may work, but it's at every 20 minutes starting at the hour

=IF(NOT(MOD(MINUTE(NOW()),20)),$A$1,"Do Nothing")

I don't use formulas much so I don't know the code for "Do Nothing"
XLAdept

looks to me like it is?

Hi Zit1343,

I couldn't find "do nothing" code so I've written:

Function On20(a As Range) As Variant
Static b
If b = 0 Then b = a
On20 = b
If Minute(Now()) Mod 20 = 0 Then
On20 = a: b = a: End If: End Function

It relies on frequent updating of A1 but it seems to work.
So, if you use macros, put this code in a module and put:

=On20(A1)

in B1