sorting out columns but only for some rows
 

Hi,

I would like to create a macros that will sort out the first 5 rows of
my spreadsheet only. The reason for that is that in the middle of my
spreadsheet i have another group of cells that represent a table and I
don't want that one to be sorted.

How can i do that ?

Thx

Sam,

Either select just the cells that you want sorted, prior to the sort, or
insert a new row between the tables to prevent them being sorted together.

HTH,
Bernie
MS Excel MVP


"Sam" wrote in message
oups.com...
Hi,

I would like to create a macros that will sort out the first 5 rows of
my spreadsheet only. The reason for that is that in the middle of my
spreadsheet i have another group of cells that represent a table and I
don't want that one to be sorted.

How can i do that ?

Thx

Hi Sam

something along these lines

sub sortsome()

Rows("1:5").Sort Key1:=Range("a2"), Order1:=xlAscending, Header:=xlYes,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

End sub

where you have a header row (if not, change Header:=xlYes to Header:=xlNo
and A2 to A1) and you want to sort on the value in column A, if not, change
the A to whatever column you want to sort on

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Sam" wrote in message
oups.com...
Hi,

I would like to create a macros that will sort out the first 5 rows of
my spreadsheet only. The reason for that is that in the middle of my
spreadsheet i have another group of cells that represent a table and I
don't want that one to be sorted.

How can i do that ?

Thx

oops the _ was supposed to be on the same lines as the xlYes,

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"JulieD" wrote in message
...
Hi Sam

something along these lines

sub sortsome()

Rows("1:5").Sort Key1:=Range("a2"), Order1:=xlAscending, Header:=xlYes,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

End sub

where you have a header row (if not, change Header:=xlYes to Header:=xlNo
and A2 to A1) and you want to sort on the value in column A, if not,
change the A to whatever column you want to sort on

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
...well i'm working on it anyway
"Sam" wrote in message
oups.com...
Hi,

I would like to create a macros that will sort out the first 5 rows of
my spreadsheet only. The reason for that is that in the middle of my
spreadsheet i have another group of cells that represent a table and I
don't want that one to be sorted.

How can i do that ?

Thx

i've done that. but it still modifies the rows below.
You can find my spreadsheet he
http://graphicsxp.no-ip.com/share/Book1.xls
maybe I haven't been clear enough about what i want to achieve and
you'll get the visual straight away.

Thx

The recorded macro below seems to be able to do the job ..
(Sort by col C - Descending, then by col B - ascending)

Sub Macro2()
Sheets("Sheet1").Select
Rows("1:6").Select
Selection.sort Key1:=Range("C2"), Order1:=xlDescending,
Key2:=Range("B2") _
, Order2:=xlAscending, Header:=xlYes, OrderCustom:=1,
MatchCase:=False _
, Orientation:=xlTopToBottom
Range("A1").Select
End Sub

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sam" wrote in message
oups.com...
i've done that. but it still modifies the rows below.
You can find my spreadsheet he
http://graphicsxp.no-ip.com/share/Book1.xls
maybe I haven't been clear enough about what i want to achieve and
you'll get the visual straight away.

Thx