Modern Magic - How Do They Do It?
To many, this would be a trivial case (this is 100% expected), and, for those who know the nitty gritty of how performance improved going from 10 billion to 175 billion parameters, this is REALLY trivial, but, it still blows my mind that it caught THIS 😊 Q: I am using the below VBA macro to sort a column in descending order, but it has the side effect of doing the equivalent of CTRL+HOME , so I have to manually pan (scroll horizontally) to get back to the column of interest. What can I do? 🔹 Original VBA Macro: Sub sort_col_desc() Dim TableName As String Dim TableHeader As String TableName = ActiveCell.ListObject.Name TableHeader = ActiveCell.ListObject.HeaderRowRange.Cells(1, ActiveCell.Column - ActiveCell.ListObject.Range.Column + 1).Value With ActiveCell.ListObject.Sort .SortFields.Clear .SortFields.Add2 Key:=Range(TableName & "[[#All],['" & TableHeader & "]]"), SortOn:=xlSortOnValues, _ ...