Countdown Timer

I have VBA code for a Countdown timer that works great for one cell per sheet, but I want it to work for multiple cells in the same column.

This code works for one cell. In this case it is referencing cell G6. But I would like to run the timer on any active cell in Column G.

I tried this (Set Count = ActiveCell.Range("G4:G100").Select), and some other variations of that same concept, but it does not work. I get error type "Mismatch". I'm completely stuck. Any help is much appreciated.

Please Login or Register  to view this content.

Hi gkokaisel and welcome to the forum,

Could you first EDIT you post above and then click on the "Go Advanced" to view the question with more Icons above the message area. Select all the text that is code and click on the "#" Icon. This will put code tags around your code and be following the rules of this forum. It makes your code much easier for us to read also.

Then after doing the above read http://www.ozgrid.com/forum/showthread.php?t=79722 to see if your question is answered theres.