Digita
09-11-2008, 10:34 PM
Hi guys,
Applying DRJ's code (http://www.vbaexpress.com/kb/getarticle.php?kb_id=103) in the Kb to sort a 1-D array which contains numbers and text. If an array contains: "James", "Mary", "Tom", "Beth", "Bob", "Chris", "Daniel", "Lari", "Al", "Teresa", 10, 2, 1, the sorted output shows: 1, 10, 2 and followed by names in alphabetical order.
How can we have the number part to be shown as: 1, 2, 10?
Thanks & regards
Applying DRJ's code (http://www.vbaexpress.com/kb/getarticle.php?kb_id=103) in the Kb to sort a 1-D array which contains numbers and text. If an array contains: "James", "Mary", "Tom", "Beth", "Bob", "Chris", "Daniel", "Lari", "Al", "Teresa", 10, 2, 1, the sorted output shows: 1, 10, 2 and followed by names in alphabetical order.
How can we have the number part to be shown as: 1, 2, 10?
Thanks & regards