@ snb,

Nice code.

Why didn't you assign the zero day value to a variable outside the loop? Wouldn't it be faster?



@ Mark,

Your UserForm Calendar would be a nice addition to the KB after you get it working, perfected, and cleaned up. Why don't you submit it to the Potential KB Entries Folder when it's working and we will help you perfect and generalize it.