mferrisi
04-09-2007, 10:33 AM
Both MutliArr(abc, 2) and at show the same date, but the MultiArr(abc,2) has the date in parenthesis, and thus they never execute the "then" statement. Any suggestions?
Thank you very much,
Matt
at = CDate(Application.Run("EOMONTH", iDte, 0))
For ACounter = 1 To DataCount
MultiArr(ACounter, 2) = Format(Cells(ACounter, 2).Value, "mm/dd/yyyy")
Next ACounter
iDte = Now()
at = CDate(Application.Run("EOMONTH", iDte, 0))
If MultiArr(abc, 2) = at Then ....
Thank you very much,
Matt
at = CDate(Application.Run("EOMONTH", iDte, 0))
For ACounter = 1 To DataCount
MultiArr(ACounter, 2) = Format(Cells(ACounter, 2).Value, "mm/dd/yyyy")
Next ACounter
iDte = Now()
at = CDate(Application.Run("EOMONTH", iDte, 0))
If MultiArr(abc, 2) = at Then ....