MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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)