hi clr


i did that

and i can and have developed a macro for 10 sets of values

but i have data that is 15 pages long in every analyses
so i want to make a macro with a do loop and within it want a sort (are
u understanding me or is it confusing:)) as i want to standardize the
procedure.


regards
indraneel
CLR wrote:
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