I'm not sure what you mean by resetting, but I thing Timer1_Timer.Enable = True will turn on the timer, and Timer1_Timer.Enable = False will turn it off. Hope that helps.
Thanks, dsi. I plugged your code into an empty project. And, as you promised, it worked. So, I applied the same methodology to my app, but it wouldn't work. I worked throught the code systematically and finally discovered that it was the formatting I was doing, namely, using the .Select method...
You could try the WorkSheets.UsedRange method to find the range of cells to search for the last cell containing data. This method will return the smallest rectangle around the used cells in a worksheet. Becareful with this method, though. Sometimes it returns the ranges for cells that once...