sorting a #name?

  • Thread starter Thread starter Steven
  • Start date Start date
S

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
 
Back
Top