Many thanks Tom. I knew I was missing a bit of logic somewhere in the
setting of my range object and which you've masterfully supplied. I can
now proceed and translate the idea of "one-off" mass action (not
necessarily for deletions) in some projects.


And thanks Eric for the input. I however cannot see how the use of
Specialcells can demonstrate the use of overtly "pooling" like cells
together. If my understanding of Specialcells method is correct, it
does so but only implicitly or covertly. Thus,
*Range("a:a").SpecialCells(xlCellTypeBlanks).Entir eRow.delete* will
pick out all blank cells in one fell swoop and delete them. There is no
place for direct "pooling"which was the object of my exercise.


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=393897