I'm getting a type mismatch error when I check for an empty cell in a row
which has a date in it. The following attempts have produced the type
mismatch error:
do while .Range(strDateCell).Value = vbNull
do while IsEmpty(.Range(strDateCell).Value) = false
do while .Range(strDateCell).Value< format("01/01/1980","mm/dd/yyyy")
I'm SURE that this is so unbelievably simple, I just can't think of it right
now.
TIA
Ron
This message was edited by rlevau on 2002-04-09 12:47
which has a date in it. The following attempts have produced the type
mismatch error:
do while .Range(strDateCell).Value = vbNull
do while IsEmpty(.Range(strDateCell).Value) = false
do while .Range(strDateCell).Value< format("01/01/1980","mm/dd/yyyy")
I'm SURE that this is so unbelievably simple, I just can't think of it right
now.
TIA
Ron
This message was edited by rlevau on 2002-04-09 12:47