why sort decending doesn't refresh when data changes?
P Pete_UK Nov 4, 2008 #2 It's a one-off command that sorts when you do it (rather like autofilter). If you wanted to update the sort order continuously, you could do it by formula or have an event macro running in the background. Hope this helps. Pete
It's a one-off command that sorts when you do it (rather like autofilter). If you wanted to update the sort order continuously, you could do it by formula or have an event macro running in the background. Hope this helps. Pete