sorting a #name?
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 |
sorting a #name?
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 |
All times are GMT +1. The time now is 05:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com