auto sorting data
Posted by Buster Aldrich on July 17, 1999 10:47 AM
I have a group of cells (range), that change as the linked workbook changes. How can I make the range of cells auto sort each time there is a change without using the "data" "sort" menus each time
Posted by george on July 22, 1999 8:41 PM
Buster - You can create an auto_open macro that will do it for you everytime the worksheet is opened.
Posted by Ivan F Moala on July 25, 1999 12:19 AM
Buster
You may want to do this when when the selection changes rather then when the workbook opens, use
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
Ivan
