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

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

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

I'd start at Chip Pearson nots on how to use application.ontime:
http://www.cpearson.com/excel/OnTime.aspx



Dr. Darrell wrote:

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

--

Dave Peterson