If you sort it in alphabetical order, don't all the blanks sort to the bottom?

Seems like that would be equivalent to deleting them

Or you can do

columns(1).SpecialCells(xlBlanks).EntireRow.Delet

of course they may not really be blanks, but are cells that look blank.
that would be different.

--
Regards,
Tom Ogilvy


"Dustin" wrote:

I was wondering if it is possible to sort a range in
alphabetical order, and delete any blank entries?




Thanks