Sorting blanks to bottom of list

[meknabusuk]

Hi, I wanted to add codes that can sort blanks to bottom of list to my specific set of codes. Below are the codes :

Please Login or Register  to view this content.

Im a newbie at vba and I record the macro, so I dont really know what I'm doing. If anyone could be kindly insert codes or modify the codes above I would be very thankful.

[davesexcel]

When sorting descending, blanks will be at the bottom as the have the lowest value.

[mjr veverka]

... codes that can sort blanks to bottom of list ...

Attach a sample 'xls' file - we don't know the layout of your data, where are those "blanks", what is in the other columns ?