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