I recorded this macro to sort a multiple ranges on the same sheet. It runs fine on my machine, but when I email it to someone else they get a runtime error 1004.
Any idea why or how I can fix it?
Sub Sort_Owner()
Range("C7:J26").Select
Selection.Sort Key1:=Range("E7")...