Excellent.

That worked. Last question, how do I insert the new data into a cell?

The worksheet is called "data" and the cell reference is held under
varaibales ("x" and "the value") and the data to input is held i
varaible "now".

This didn't work:

Worksheets("Data").Cells(x, thevalue) = now

Thanks agai

--
thegoone
-----------------------------------------------------------------------
thegooner's Profile: http://www.excelforum.com/member.php...fo&userid=3661
View this thread: http://www.excelforum.com/showthread.php?threadid=56363