application input box return different date formats leading to wrong resutl in auto filter

Dear all,

I am working on a report which is attached along with the code.Application input box takes date and the filters coulmn"A" according to this date. Problem is that some values it returns correctly for example 5/5/2012, 6/5/2012, 7/5/2012 and data filter is ok BUT when I put 20/5/2012 then filter works wrongly returning no data at all. program hangs up.

secondly, at line 135 of code, if the date is wrong due to filter returning empty fileds and content of "Raw" sheet is empty then workbook must close, but it is hanged up due to above malfunctioning

any help is appreciated!

BR,
Shaukat

Try looking into CDate.

It converts a datatype to date datatype.

Please Login or Register  to view this content.

First off all i would suggest you clean up the code a bit, before troubleshooting this error.

Your code does a lot of selecting and activating, wich slows down the code, and makes it harder to read.

Example:

Please Login or Register  to view this content.

Can be rewritten like this

Please Login or Register  to view this content.

Or

The whole column

Please Login or Register  to view this content.

Try and clean the code up a bit, then maby the error will be more visible for you.