I have a worksheet that has three sections of data on it. The sections are separated by rows. I want to sort the top section by the last column in that section. I select the range (A13:AE28), then right click the range and choose sort/custom sort. I deselect the headers option because there are three levels of headers so I only want to select the range. Then I choose sort by column AE. Then I choose sort largest to smallest. Column AE contains numbers. It seems simple enough but when I click sort the only column in the range that ends up sorted is column AE -- not the entire range. Am I missing a step? This happens if I code the sort also. I eventually want to code the sort and attach it to a click event but I can't even get the sort to work properly by doing it manually.