sorting w/ blank cells

is there a way to sort a range, leaving all of the blank cells at the bottom
(rather than the top?)

thanks in advance,
mark

Sort Descending

If you then want to sort ascending, reduce your range to exclude the blanks
and sort ascending.

--
Regards,
Tom Ogilvy

"mark kubicki" <mark@tillotsondesign.com> wrote in message
news:eDqzJagSGHA.5468@TK2MSFTNGP14.phx.gbl...
> is there a way to sort a range, leaving all of the blank cells at the
bottom
> (rather than the top?)
>
> thanks in advance,
> mark
>
>