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

thanking you in advance


regards
indraneel

You need to give more information if you want to get explicit help on which
columns you want to sort on and whether you have a header row of field names.
I don't think you need to find the range unless you only want to sort on a
range instead of the whole sheet. Here is an example of my sort on 3 columns
with the 3 labels in the first row as the matching key.

Sub Sort()


Set rng = .Range(.Cells(1, 1), .Cells(Rows.Count, 26).End(xlUp))
MsgBox rng.Address
rng.Sort key1:=.Cells(1, 16), Order1:=xlAscending, _
key2:=.Cells(1, 19), Order2:=xlAscending, _
key3:=.Cells(1, 3), Order3:=xlAscending, Header:=xlYes, OrderCustom:=1,
MatchCase:=False, Orientation:=xlTopToBottom
End With


End Sub


" 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

thanking you in advance


regards
indraneel

You haven't!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
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

thanking you in advance


regards
indraneel

the problem that i have infront of me is something like this


I have a set of data that i get from analyses

it is a 15 page data that is pasted in excel

each page contains 10 entries in 1 column say EID element id

the data would look like
COLUMNS
EID A B C D E F G H I J K
123456
1 2 3 4 5 6 7 8 9 5 6
2 3 6 7 8 9 1 2 6 5 4
5 6 8 9 1 3 4 5 6 5 2
23564
1 2 3 4 5 6 7 8 9 5 6
2 3 6 7 8 9 1 2 6 5 4
5 6 8 9 1 3 4 5 6 5 2

AND SO ON

ok now what i want to do is sort by column K say(Descending) then want
the highest value to be displayed with the Element Id
so that i can move them to a new sheet where i can again sort the same
for say col K again


i was able to do it for 1 Page that is 10 values but i used the Record
Macro button but i dont see it as a good way to go and so wanted to see
how can i do it using do or if command and within it a sort command
that selects the on screen value


thank you in advance

regards
indraneel


@ BOB YOU HAVENT = ??????
Bob Phillips wrote:
You haven't!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
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

thanking you in advance


regards
indraneel

hi


i was able to solve the hard part that is getting to sort now i want to
link sheet two values with sheet one and again sort can anyone help me
eith the linking



thanks in advance


indraneel
wrote:
the problem that i have infront of me is something like this


I have a set of data that i get from analyses

it is a 15 page data that is pasted in excel

each page contains 10 entries in 1 column say EID element id

the data would look like
COLUMNS
EID A B C D E F G H I J K
123456
1 2 3 4 5 6 7 8 9 5 6
2 3 6 7 8 9 1 2 6 5 4
5 6 8 9 1 3 4 5 6 5 2
23564
1 2 3 4 5 6 7 8 9 5 6
2 3 6 7 8 9 1 2 6 5 4
5 6 8 9 1 3 4 5 6 5 2

AND SO ON

ok now what i want to do is sort by column K say(Descending) then want
the highest value to be displayed with the Element Id
so that i can move them to a new sheet where i can again sort the same
for say col K again


i was able to do it for 1 Page that is 10 values but i used the Record
Macro button but i dont see it as a good way to go and so wanted to see
how can i do it using do or if command and within it a sort command
that selects the on screen value


thank you in advance

regards
indraneel


@ BOB YOU HAVENT = ??????
Bob Phillips wrote:
You haven't!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
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

thanking you in advance


regards
indraneel