This one now works great, but also does not return any results when I enter the payroll date I'm looking for.

Again, I can't thank you enough for your help on this!

Quote Originally Posted by sintek View Post
Yep, sorry...Need to declare i As a Double and not Integer
So
Dim I As Integer
must be
Dim i As Double