Clearing the contents of a single cell every 30 seconds.......

[jmhassetmanagement]

Hi Community!

I have a niche task that I would like Excel to perform automatically for me, namely to clear the contents in cell A1 every 30 seconds on a continuous loop, when I have my workbook open.

I'm sure that this must be possible, but am presently stumped for a solution, so I would be exceedingly grateful for any suggestions you might have.

Many Thanks!

 

[VoG]

Try the OnTime method http://www.ozgrid.com/Excel/run-macro-on-time.htm