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.
Please Login or Register to view this content.
Is there an easy way to change this?
Many Thanks For Any Help!
Paul
Last edited by JBeaucaire; 01-13-2014 at 07:10 PM. Reason: Added missing CODE tags, please read and follow the Forum Rules, link in the menu bar above. Thanks.
Try this !
Please Login or Register to view this content.
Marc's code will work if you have a single cell. However, if you want to test against a range you are going to need to incorporate a loop. Just out of curiosity, why are you clearing the cells every 2 seconds
Please Login or Register to view this content.
Last edited by stnkynts; 01-13-2014 at 11:05 PM.
Hi. Thanks a lot for replying!
However the code is clearing the cell whenever any text is entered in the cell. Why would this be?
Many thanks again!
Paul
Not to worry! Managed to sort it. If anyone is interested this is the final code that I have used.
Please Login or Register to view this content.
Last edited by paulm99; 01-14-2014 at 06:55 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks