If you are sorting in ascending order, the blanks should be moved to the
bottom.
--
Gary''s Student - gsnu200852


"Anthony" wrote:

autosort with blank cell not moving eg
1-3-5-2-4- "-represent blank cell" when sorting i want
1-2-3-4-5- leaving blank cells where thy are