Verifying Date Format in Excel 1

[Bass71]

Hello again:

This simple syntax question is dogging me...

I am trying to determine if a cell value is a date, but I cannot find the syntax. Among others I have tried:

If IsDate(ActiveCell) Then...

Thanks so much................RO

 

[VBAjedi]

Bass71,

Try:

If Vartype(ActiveCell.Value) = vbDate Then
....
End If


Let me know if that does the trick for you!



VBAjedi

 

[Bass71]

Most helpful, thanks VBA jedi!!