On Thu, 20 Apr 2006 18:11:59 +0100, "Bob Phillips"
wrote:

msgbox "The cells " &
activesheet.usedrange.specialcells(xlcelltypeblan ks).address & " are all
blank

Brilliant Bob.

Why can I never see the simple answer, and overcomplicate things.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________