Evaluate for empty cell

rlevau · Apr 9th, 2002, 01:47 PM

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 ]

Al Chara · Apr 9th, 2002, 01:52 PM

Do While Range(strDateCell).Value <> ""

This will do while the value is not empty. Is that what you want?

rlevau · Apr 9th, 2002, 01:58 PM

Thank you so very much!

Apr 9th, 2002, 01:52 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Do While Range(strDateCell).Value <> "" This will do while the value is not empty. Is that what you want? __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 01:47 PM	#1
rlevau New Member Join Date: Apr 2002 Posts: 3	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 ]

Apr 9th, 2002, 01:58 PM	#3
rlevau New Member Join Date: Apr 2002 Posts: 3	Thank you so very much!