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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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 here:
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 <at>yahoo<dot>com
----
"Sam" <[email protected]> wrote in message
news:[email protected]...
> i've done that. but it still modifies the rows below.
> You can find my spreadsheet here:
> 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
>