No, I mean you should specify the sheet for the ranges you use as the Key and SetRange arguments, which you weren't doing before.

I suspect Excel is smart enough to simply base the sort on the column(s) you choose for the keys, but I can't see any benefit to not specifying the same rows for each column.