Sort

[jub6]

Hi

I need a VBA code to sort a range.Basically not using a macro i would require the logical code to sort a range.

Regards
John

 

[Domski]

VBA code and Macros are basically the same thing.

Have you tried using the macro recorder?

Dom

 

[jub6]

Hi

I need the logic behind Sorting to apply it somewhere else ... so wanted to know how it works ...

j

 

[Domski]

There are different sorting algorithms, Bubble Sort is quite a popular one.

A quick Google will come up with plenty of explanations as to how they work like this: http://csdir.org/Programming/Algori...rting/quicksort-and-bubblesort-explained.html or http://en.wikipedia.org/wiki/Bubble_sort

Hope it helps,

Dom

 

[mikerickson]

http://en.wikipedia.org/wiki/Sorting_algorithm

has a variety of methods to do a sort.

Do you have a question about sorting in Excel?