MsgBox not returning data within cells

[Sighter]

PURPOSE OF MACRO:
Hey everyone! I have a simple macro that compares dates in a column to certain words in the following column, as shown below. The end result should be the oldest date that matches the proposed "Phrase1".

ISSUE:
This worked Friday, but I accidentally saved it as a .xlsx, thus deleting the macro. I redid it today and for some reason MsgBox is now not returning the date within the cell (10, 3), or data from any cell for that matter. It simply returns a MsgBox that contains "00:00:00". What is my issue?

Please Login or Register  to view this content.

[JosephP]

what is in C10?

[Sighter]

The following date: 7/11/2013. I've tried formatting the cell as "General" and as "Date". Neither option solved the issue.

[JosephP]

is the code in a worksheet module that is not Sheet1?

[Sighter]

I am a complete idiot. I'm sorry for wasting your time. You inadvertantly made me realize I had my x's and y's reversed! It should be (n, 10) not (10, n)! Thank you

[JosephP]

You inadvertantly made me realize

that's actually why I said C10 and not Cells(10, 3) ;-)

you're welcome

[Sighter]

Well thank you very much! I've already wasted 2.5 hours on this stupid issue.