Try making these ranges visible with a filter and it may work.

--
Regards,
Tom Ogilvy


"Steven" wrote in message
...
is it posible to sort a range name? i have one called
"m_sort_cells
=M!$A$13:$AA$51,M!$A$72:$AA$110,M!$A$131:$AA$169,M !$A$190:$AA$228"
and would like to assign a macro to a button or menu, that would sort
assending using colum E and C, with one click.
click again and it would sort using colum C and E assending, but it would
also need to skip blank cells.

Thanks for your help!

Steve