I have the sort completed automatically through vba. How do you tell the
sort to only do the numbers?

"Jim Cone" wrote:

Sort all of your data ascending.
That puts the numbers at the top.
Then sort just the rows with the numbers descending.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Jeff G"
wrote in message
I have data that is a mix of numbers and text that is being sorted. The text
is always the same "NO DATA SUBMITTED".

I need to sort the data showing the numbers in decending order at the top of
the list. If I sort the data range in decending fashion, the text is brought
to the top because of the default sort order.
Any ideas on how to do this? Can the default sort order be changed for this
worksheet only? Any ideas on other ways to do it would be appreciated.

Thanks.