How do I sort a range on a column with numbers (integers) so that all record
having a zero in that column will be at the end of the list.

Thanks

You would need to use a helper column that will be your first sort key. Put
a formula in that column that will produce a result that sorts to the bottom
if the referenced column contains a zero.

=if(c2=0,"Z","A")

drag fill down the dummy column.

--
Regards,
Tom Ogilvy

"Rafi" wrote in message
...
How do I sort a range on a column with numbers (integers) so that all
record
having a zero in that column will be at the end of the list.

Thanks

My answer assumed you wanted to sort ascending for the other numbers.

--
Regards,
Tom Ogilvy

"Rafi" wrote in message
...
How do I sort a range on a column with numbers (integers) so that all
record
having a zero in that column will be at the end of the list.

Thanks

I need to execute the sort from VBA so I am afraid this will not work.

Thanks

"Tom Ogilvy" wrote:

You would need to use a helper column that will be your first sort key. Put
a formula in that column that will produce a result that sorts to the bottom
if the referenced column contains a zero.

=if(c2=0,"Z","A")

drag fill down the dummy column.

--
Regards,
Tom Ogilvy

"Rafi" wrote in message
...
How do I sort a range on a column with numbers (integers) so that all
record
having a zero in that column will be at the end of the list.

Thanks