Ranking multiple ranges on the same sheet

[N13NA]

Hi, this is probably simple but I'm trying to rank multiple ranges on the same sheet, all 4 ranges would have the same width with and length but the length varies from sheet to sheet, the first range ranks perfectly but the same piece of code does not seem to sort the remaining 3 ranges, i have tried selecting the ranges before applying the sorting, it selects the correct ranges. No error came up, it just doesn't sort.

Also I would like to apply this to each sheet in the workbook that contains the word "Ranking", if anyone has a quick way to do this that would be great.

Thanks!!

My code:

Please Login or Register  to view this content.