If the information is contiguous and you have empty cells around the
final sort  grouping, you could use the CurrentRegion property. This
selects the group of cells around the selected cell up to the first
empty row and first empty column. Search for CurrentRegion Property
in VBA Help.