I would like a range of cells to become blank if they are idle for

D

Dr. Darrell

I would like a range of cells to become blank if they are idle for 15 minutes.

I have an alplication where I have a machinist input data every 20-30
minutes. To avoid some possibility of data input error, I would like the data
which he has input previously to be cleared.

Is there a function that would clear the range of cells and leave them blank
and ready for the next searies of data to be input.

My Range is J5:J6

Darrell
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if there is a blank ,how to get the blank cell in a range be highlighted 2
need help in fine-tuning a formula that removes blank cells in a column range 3
how can I lock/unlock a range of cells depending on state of a checkbox? 4
How To Have A Cell Be Blank If... 2
How do I clear a form? 0
reverse pasting rows with alternate blank cells 0
Saving a range for later reference 0
If statement for a range of cells 3

Top