Hello all, I have a macro set-up to check a through a range of cells looking for members code 1 & changing it to a sequential number & dependent code 2 & setting it to null.

What I'd like to do is when it pops up the msgbox at the end informing the user how many members records were changed & dependent records changed I can also include something like "Task completed in ## seconds".

How do I set up a timer to count of the seconds from the start of the code until the last record has been changed?

Do you need me to post the code I have written so far?

Thanks in advance,

eric