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

Macro to hide blank cells in a range 1
VBA Code- Copy & Paste in Blank Range 9
Applying Formulas to a Range in a Worksheet 4
Need a formula to locate the blank cells within the range 2
macro to unlock and lock cells in password protected sheet 3
How To Have A Cell Be Blank If... 2
Hide row if all cells in another range are blank 2
how to average a range of cells and ignore #div/0! answer 4

Top