sorting a #name?

[Steven]

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

 

[Tom Ogilvy]

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