sorting in a shared wookbook
I have a workbook that has 12 macros setup that sort certain cells. When I
share out the wookbook I can only sort rows of cells, not a selected range, either through the menu or via the macro. Is there a way to sort only certain rows or certain selected cells in a shared wookbook. Any advice greatly appreciated. |
sorting in a shared wookbook
I have the same problem and am looking for an answer also. When I share my
work book, the sort now selectects every column for all rows selected. Even though the column are not part of the selection. I have broken down my macros to show the range selected before the sort and that is working properly. but excel still sorts all adjacent columns to the selection. When unshared the macro sort works fine. Hope someone has an answer. "Andrew" wrote: I have a workbook that has 12 macros setup that sort certain cells. When I share out the wookbook I can only sort rows of cells, not a selected range, either through the menu or via the macro. Is there a way to sort only certain rows or certain selected cells in a shared wookbook. Any advice greatly appreciated. |
All times are GMT +1. The time now is 09:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com