Try this: Sub SelecteerDatum() Cells(Application.Match(CLng(Date), Range("A:A"), 1), "A").Select End Sub