Dave,

Try

If IsEmpty(ActiveCell) Then
Exit Do
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Dave" wrote in message
...
What is the function to end a Do While statemnet when
encountering a null,
blank or empty cell?

Thank you
Dave