Beginner1200
New Member
- Joined
- Jan 18, 2023
- Messages
- 16
- Office Version
- 2019
- Platform
- Windows
I want to sort the range "B5" order Ascending. But it has to leave the >>100.00; Hull<< out of the sorting progress.
Sorting the whole row with data but it has to leave the last cell in ascending order out of the sorting...
Hope my post gives any sense or meaning and hope anyone can give me hint to get it right
Sorting the whole row with data but it has to leave the last cell in ascending order out of the sorting...
Hope my post gives any sense or meaning and hope anyone can give me hint to get it right
VBA Code:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Range("B5", Range("B5").End(xlUp)).Sort Key1:=Range("B5"), Order1:=xlAscending, Header:=xlYes
End Sub