Hi Yvette

If the "blank" rows are sorting to the top, then they are not blank but
contain spaces. Blank rows will automatically fall to the bottom of a
sorted list.
Try sorting descending first, then delete all rows below your data.
Then sort ascending again.

--
Regards

Roger Govier


"Yvette" wrote in message
...
Hi ppl,

After pasting and sorting say A1:F20 any blanks always end up top when
using an acsending sort.

How can I (using code) delete any blank rows.

TIA

Yvette