Macro to Sort in Specific Order

I have VBA Code to sort the data on sheet ?Account Numbers? by Col C in the same order per sheet ?Unique? in Cell Z1 to Z5


When Runing the code, I get a run time error : Appllication Defined Error

Please Login or Register  to view this content.

My Full Code is

Please Login or Register  to view this content.

Kind Test & Amend my Code


I have also posted on https://www.mrexcel.com/board/thread...-sort.1240892/

try

Please Login or Register  to view this content.

Thanks for the help Jindon


Your code works perfectly