You need to have a variable to store the target row number and incremen
it with each cycle of the macro (don't forget to initialise it at th
beginning of the macro with rw=0 or whatever).

Something like :-
'--------------------------------------------------------------------
rw = rw + 1
Worksheets("DataStore").Cells(rw, 1).Value = MyTime
Worksheets("DataStore").Cells(rw, 2).Value = MyValue
'----------------------------------------------------------------------

--
Message posted from http://www.ExcelForum.com