Hi Ken,

Range("A2:A50").SpecialCells(xlCellTypeBlanks)

defines the blank cells in Range("A2:A50").

That seems entirely logical to me.

What range do you want to include?

---
Regards,
Norman



"Ken Johnson" wrote in message
ups.com...
Range("A2:A50").SpecialCells(xlCellTypeBlanks) does not include blank
cells below the last non-blank cell in A2:A50. Is this correct
behaviour? If so it seems illogical to me. Or, am I doing something
wrong?
Ken Johnson