Is there a way to have Excel perform a task using vba such as sorting a column, but do it in the background so you don't see it happening? I can see the flicker as Excel jumps from my current location to the column it needs to copy, and then paste and sort to the adjacent column, and then proceed to jump back. It happens quick, but it's just annoying to me to see that faint flicker every time. I'm hoping there is a function/command I can add to the macro that will still process the code, but maybe not update the screen during that split second.
Hope that makes sense!
This is the code I'm using:
Range("BS4:BS51").Select
Selection.Copy
Range("BT4").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("Game").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Game").Sort.SortFields.Add Key:=Range("BT4"), _
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Game").Sort
.SetRange Range("BT4:BT51")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("B4").Select
Bookmarks