excel - change the value of a cell through time with the next item in column -

i know if there way change value of cell every 10 seconds. new value next cell in column , forth until went through none-blank cells.

you can use application.ontime function call function every 10 seconds:

dim integer  function starttimer()  'set counter 1 = 1 'call function timerfunction end function  function timerfunction()  'write current time column sheets("table1").cells(i, 1).value = format(now, "hh:mm:ss")  'if counter = 10, stop timer if = 10      exit function end if  = + 1 'call function delay of 10 seconds application.ontime + timevalue("00:00:10"), "timerfunction" end function 

so change if condition matches task. maybe this: if current column = last used column (if understood right)