Hi Dave,

Something like this...

Do Until rngYourCell.Value = ""
'loop activity here
Loop

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM



"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