http://www.excelforum.com/excel-prog...t-by-date.html

long thread sorry...

I have tried a variety of things and the biggest problem is that it fine on my excel but when he runs it on his actually data he gets a type mismatch error (13).

Any help would be great...thanks....