help needed...

[sameer27p]

hi all,

i am looking out for a macro code which can sort a column in ascending order..

i have a column K which contains positive and negative values..i need to sort this column in ascending order..then i need to display the grand totals of the positive and negative values by inserting rows....

can someone please help me out in this ? i already have a macro which does a lot of other things,in which i need to embed this code !

[dglienna]

one way is to do a bubble sort, which can be found by searching the forum. it is not the fastest way, but it works.

[BrianB]

Why not just record a macro of Excel's Data/sort ??