View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dr. Darrell Dr. Darrell is offline
external usenet poster
 
Posts: 74
Default 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