My case statement worked until I added the range as shown at the end of the case line. I don't know how to code this. I just added the between portion for example of what I am looking for.
![]()
Select Case ActiveCell.Column Case 4, 5, 6, 7, 8, 9, 10, 11, 12, between 30 and 77 GoTo SortColumnOnly End Select
Bookmarks