I am adding some dates to an array of variant Date type and I get the above error and I thought this was correct.
I searched here (post #2) and found the answer to be the same as I am doing:
Code:
For i = 0 To 13
    If chkHistory(i).Value = vbChecked Then
        GradeHistoryDates(i) = dtpHistory(i).Value
    Else
        GradeHistoryDates(i) = Null
    End If
Next i