simple date comparison - code review

Can someone review my code below and let me know if you see anything I'm doing wrong? I'm trying to compare 2 dates, but I keep getting "Invalid procedure call or argument" on my first If line. When I step through, startDate = 6/29/2013 and compareToDate = 7/1/2013. I'm casting both as dates, what else am I missing?

Please Login or Register  to view this content.

Try the following tested in Excel 2003, which should get you pointed in the right direction:

Please Login or Register  to view this content.

Thanks for the response, but my dates are valid. Users can't enter invalid dates as I have data validation set on all date cells. When I step through and check my variables, they're set to valid dates. I'm starting to wonder if the problem lies elsewhere because my casting is right and the dates are indeed valid

It was worth a try. The routine works for me when I substitute generic code for your project specific code.
My next suggestion is to remove the offending code using 'Conditional Compilation' until you find what is causing the error.

Please Login or Register  to view this content.

You will know that 'Conditional Compilation' removed the code, when you try to set a 'Breakpoint' in the offending section and VBA won't let you set the 'Breakpoint'.

Ya this method gets called through other methods, so I think I have some further investigating to do. Although, everything was fine until I wrote and called this!

In the Excel 2003 debugger you can access the call stack which can show you where the error came from:
a. In the debugger menu View > Call Stack or
b. Control L

Cool thanks I will look at this when I get home this evening