Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How Do I Reset the Timer in Visual Basic?
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.- DaytonEE
- Post #2
- Forum: Microsoft Visual Basic
-
Killing Excel after Creating a Workbook in VB
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...- DaytonEE
- Post #3
- Forum: Microsoft VBA - Visual Basic for Applications
-
Excel/VBA: Programming IF statements for a range of cells
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...- DaytonEE
- Post #2
- Forum: Microsoft Visual Basic
