I currently use the following code to clear certain cells at a time interval of 2 seconds:
However I would like to clear the cell whenever the cell contains a specific word, ie Total. The cell is updated automatically from another source.![]()
Sub CC() Sheet1.Range("O9,O11,O13,L10,L12,L14").ClearContents Application.OnTime Now + TimeValue("00:00:02"), "CC" End Sub
Is there an easy way to change this?
Many Thanks For Any Help!
Paul
Bookmarks