Hello everyone, its been a while 
I have a spreadsheet has multiple sheets.
On sheet 1 values are entered and formulas applied
On sheet three formulas read from sheet one and are updated automatically
I have added an AutoSort capabilty by
pressing Alt-F11 and choosing worksheet
then I entered in the following code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A2:H5").Select
Selection.Sort Key1:=Range("C2:C5"), Order1:=xlDescending, Key2:=Range("A2:A5"), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
End Sub
The sort is working as expected however, I do not have access to the page anylonger to make changes.
I am not sure how to release the Select once the page autosorts.
Any ideas ?
Thank you
Bookmarks