Try using the Macro Recorder.........Tools Macros Record new Macro, while
you go ahead and perform the sort you want by hand one time. The Recorder
will make a macro as you go.........then you can do ALT-F11 and view/edit it.
Post back if you run into trouble.

hth
Vaya con Dios,
Chuck, CABGx3





"indraneel" wrote:

i want to write a macro
that would contain a do loop
and within that do loop i want to do sorting

can any one help i cant understand of how to select the cells that i
want to sort in VBA language

hope i have made my self clear


regards
indraneel